add a number every two weeks

B

Big Rob

I need to set up a worksheet that calculates vacation time earned per pay
period. I need a formula to add 6 hours to a cell every two weeks. Can this
be done?
 
D

daddylonglegs

If you want the result in time format try....

=(INT((TODAY()-DATE(2006,11,15))/14)+1)*"06:00"

format as [h]:mm

this will show 06:00 on the date in the formula and increment by 6 hrs every
14 days

If you want to make it easier to maintain put the start date in a cell, e.g.
A2 and the number of hours (06:00) in another, e.g. B2 and use the formula

=(INT((TODAY()-A2)/14)+1)*B2
 
Top