ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update dates annually (https://www.excelbanter.com/excel-worksheet-functions/265814-update-dates-annually.html)

Misty Sunshine
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?

wickedchew
Quote:
Originally Posted by Misty Sunshine (Post 959352)
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?
=YEAR(TODAY())

wickedchew
Quote:
Originally Posted by Misty Sunshine (Post 959352)
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?
Or you can check the attachment if the solution fits your query at this post:
http://www.excelbanter.com/showthread.php?t=265827


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com