What formula will get a cell to update when the month changes
 

I have a spreadsheet that I need to show how much vacation time a person
accrues each month. I would like a formula that would update the total amount
by the amount given each month when the month changes. Help?

What formula will get a cell to update when the month changes
 

When does the vacation year start?

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"lesterslamb" wrote in message
...
I have a spreadsheet that I need to show how much vacation time a person
accrues each month. I would like a formula that would update the total
amount
by the amount given each month when the month changes. Help?

What formula will get a cell to update when the month changes
 

When does the vacation year start? Is there a sliding scale of vacation
days accrued? Do you want to count only completed months only. For example
if someone starts today does he/she start accruing vacation days only from
the 1st of next month?

--
Regards


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"lesterslamb" wrote in message
...
I have a spreadsheet that I need to show how much vacation time a person
accrues each month. I would like a formula that would update the total
amount
by the amount given each month when the month changes. Help?