Vacation Due

[SilverM78]

Duane Thanks tor your reply.
But I am still not getting result??
Mr Kusleika and yourself are on the right track.
My Excell skills are not to that level yet but I am getting ideas from
your replies.
It would be ideal to show only one of three answers to formula;
40 hours for 6 months
80 hours Due Jan 1st after 1 year anniversary
120 hours Due Jan 1st after 7 year anniversary

I am getting the idea my question does not have simple solution or I am
posting it incorrect.
But I appreciate your response just the same .
Thanks

 

[duane]

=IF(A11>=DATE(YEAR($A$10)+8,1,1),120,IF(A11>=DATE(YEAR($A$10)+2,1,1),80,IF(A11>=(IF(MONTH($A$10)<7,(DATE(YEAR($A$10),MONTH($A$10)+6,DAY($A$10))),(DATE(YEAR($A$10)+1,MONTH($A$10)-6,DAY($A$10))))),40,0)))

with start date in a10 and date in question in a11

i had some parenthesis wrong before - sorr

 

[Dick Kusleika]

Silver

I didn't realize that you had responded. If you reply to my post, I'll be
sure to notice.

Maybe I'm making this too complicated. I assumed you wanted to accumulate
all the vacation that has been awarded to that person to date. Do only want
to show what was awarded on the most recent award date? From your example
of 3/2002 = 40 and 3/2004 = 80, what would you expect for 3/2005?