Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Adding Sick Time

  1. #1
    Guest

    Default

    I have set up a worksheet for the year with every date on it, I would like Excel to add 12 hrs on the 1st day of each month, to my sicktime column, but not until the 1st day of every month occurs. Can it be done?

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try using an If statement with the Date function. IF Date=first day of the month Then add 12 hours to sick column.

    Hope this helps.
    Kind regards, Al

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •