I've got a formula for figuring vacation days as shown below. It works beautifully for me.
In COLUMN A I enter a code that represents a personal day, Sick Day, etc.
In COLUMNS B AND C are the start and end dates. The Third COLUMN is the total days.
Here's the formula ...
=IF(OR(ISBLANK(B10),ISBLANK(C10)),"",C10-B10+1)
Now, I need to allow for half days as vacation ... and it's messing me up.
COL A COL B COL C COL D
HD 10/10/06 10/10/06 .5
I need help adjusting my formula so that if it sees the "HD" code in Column A, it will apply a calculation for a half day.
I'm sorry if this is vague ... I've been messing with it for two days and just can't seem to get something that will work.
Regards,
Kevin!
In COLUMN A I enter a code that represents a personal day, Sick Day, etc.
In COLUMNS B AND C are the start and end dates. The Third COLUMN is the total days.
Here's the formula ...
=IF(OR(ISBLANK(B10),ISBLANK(C10)),"",C10-B10+1)
Now, I need to allow for half days as vacation ... and it's messing me up.
COL A COL B COL C COL D
HD 10/10/06 10/10/06 .5
I need help adjusting my formula so that if it sees the "HD" code in Column A, it will apply a calculation for a half day.
I'm sorry if this is vague ... I've been messing with it for two days and just can't seem to get something that will work.
Regards,
Kevin!