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
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