=IF(OR(MONTH(C4)>8,TODAY()>=DATE(2007,MONTH(C4),DAY(C4))),G3*8," ")
cell c4 is start date
The above code is in cell F6

i presented by spreadsheet to boss, they liked it but for one thing.

It is working like I think it should be, but the problem is they dont want a person vacation showing till their hire date is reached,

But from earlier post this is retro active to sept 1, 2006

so if person had anniversary date from 9/1 up to today should show their vacation hours.

so if person was hired on 11/1/1999 their vcation hours should not show up till 11/1 this year

Thanks in advance for the help using win