Automatic updating of a time bank help

it subtracts the time

Not sure I follow what you are saying. Can you give me an example?

1) Cell K31 should be =K3*K29

2) To make it easier to test, create a helper cell, (say C1) to hold "today's date" that you can manipulate manually all you want. Later make that cell =TODAY()

3) When adding two numbers just use =A1+A2 (no need for SUM(A1, A2)

4) I created a "Gross" and "Net" calculation for vacation.

See attached

Hope that helps.

Mike you are awesome! This is what I have been trying to do! Now if there was only a way to subtract hours used from the cells in B25 through B49 as that date comes up instead of all at once this would be perfect, but it will do what I need it to do.Again thank you, I'm going to go to bed because I'm getting cross eyed looking at spreadsheets but I'll finish this tomorrow and make it all pretty. Again thank you!