No problem with the questions. I appreciate your help. It's a very simple
spreadsheet that I am using to track employees' vacation time. It's one
column per employee, with the total number of vacation hours at the top. As
people take time off, I enter it into the column (below the total time off)
and it is subtracted from the total. I'm trying to get Excel to update the
total time off by adding six hours to it every pay period (15th and last day
of the month). If I could make it so six hours could be added twice monthly,
that would be sufficient, without having to bother with 30th's and 31st's and
February having 28 days, if that creates a huge complication. Please feel
free to ask any additional questions. Thanks!!

"Don" wrote:

Can you please provide more details?
How does you current spreadsheet work?
What data is there currently?
Is the two weeks able to be identified by a certain calendar of dates?