Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why doesnt my formula cell update automatically ? | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |