Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Please give me formula for automatic change date after one year,,
Ashish |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|