Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

RicOO1

Technical User
Feb 23, 2007
8
US
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
 
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)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top