Tracking "RDO's" (Regular Day's Off)

[RicOO1]

I am new to this web site and hope I am doing this right! I am trying to set up an Excel sheet for tracking employees “RDO’s” (Reg. Days Off) and am having a little trouble.
When A1 contains the date for the first of the month, G1 – AK1 equal the DayName and G2 – AK2 equal the Day number, ‘AND’, if, E1 contains “JS” (Sat/Sun), OR “SM” (Sun/Mon), OR “MT” (Mon/Tue), etc. the corresponding cell below the Day num. will then auto fill “RDO” (Regular Day Off). I have tried “=IF(AND(G1=”Sun”,E4=”JS”,OR(E4=”SM”,”RDO”,IF(AND(G1=”Mon”,E4=”SM”,OR(E4=”MT”,”RDO”, . . . etc.,etc.,etc. . . . ,””))))))”. I either wind up with “########” in G1 or I get the “RDO” but then when I change the date in A1 to the next month it goes all wacky. Any help out there??
Thank,
Pixiegirl1 P.S. I’m not a student doing homework, I’m 59 yrs. Old.

A B C D E F G H I J K L M
1 2/1/07 EMPLOYEE LAST REG LOC- Thu Fri Sat Sun Mon Tue Wed
2 TITLE NAME FOUR SHFT RDO ATION 01 02 03 04 05 06 07
3 STSO SMITH, B. 0000 1 JS XY RDO RDO
4 STSO THOMAS, S. 4444 1 TW XY RDO RDO
5 STSO BROWN, J. 2222 2 SM RZ RDO RDO
6 LTSO VERGA, L. 3333 1 TF RZ RDO RDO
7 LTSO FERO, S. 7777 2 SM XY etc., etc., etc., etc.
8 TSO JONES, T. 5555 1 MT XY
9 TSO WALKER, F. 0505 2 WT RZ
10 TSO WALKER, J. 9119 2 JS RZ
11 TSO MARK, P. 4140 2 SM XY
12

 

[mrdenny]

You'll want to post this in the Office forum forum68 or the VBA forum forum707.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com