ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/252686-formula.html)

ashish

Formula

Please give me formula for automatic change date after one year,,

Ashish

Bernard Liengme[_2_]

Formula

If you mean something like: A1 has a date and in B1 you want the date for
following year then
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Ashish" wrote in message
...
Please give me formula for automatic change date after one year,,

Ashish

All times are GMT +1. The time now is 02:36 PM.