I'm trying to create a formula to calcuate vacations days, onee cell has # of
days worked and I want another cell to calculate # of vacations by # of days
works, i.e for every 365 days worked, each employee receives 5 days (40
hours) of vacation. 730 days they have 10 days (80 hours), 1095 days worked
they have 15 days (120 hours), etc., etc.

=IF(A1=365,40,0) this works for the first year but doesn't account for
730, 1095, etc.

any advice would be greatly appreciated
--
thanks,
John