| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Update dates annually
I need to have excel calculate a formula each month from a stationary date which I can do with =date however at the beginning of each new year I need the stationary date's year to change. Is there a way to do this?
|
|
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
|
#3
|
|||
|
|||
|
Quote:
http://www.excelbanter.com/showthread.php?t=265827
__________________
Asobi Wa Owari Da |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update 2009 dates to 2010 dates | Excel Discussion (Misc queries) | |||
| formula to calculate sum of payment increased by 3% annually | Excel Discussion (Misc queries) | |||
| HOW TO MAKE WEEKLY,MONTHLY,ANNUALLY INCOME AND EXPENSE REPORT | Excel Discussion (Misc queries) | |||
| quarterly, semi-annually?? | Excel Discussion (Misc queries) | |||
| Auto change defined name ranges on Jan 1st annually | Excel Worksheet Functions | |||
Hybrid Mode
