Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lesterslamb
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why doesnt my formula cell update automatically ? Wozza Excel Discussion (Misc queries) 7 January 6th 09 02:49 PM
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 10:14 PM
Dates of a Day for a month & year cell formulas mikeburg Excel Discussion (Misc queries) 2 December 29th 05 11:14 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 06:30 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"