×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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                                                    
                             

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

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
http://www.mrdenny.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close