date calculation

[ushaanu]

Hi all,

I have some dates with me I need add one year add .

like date is 17/02/2015 next date will be 16/02/2016.

Thanks
Anu

 

[Khalid NGO]

Hi Anu,
Try this:
=DATE(YEAR(A2)+1,MONTH(A2),DAY(A2)-1)

where A2 contains 17/02/2015
YEAR(A2)+1 does the trick for year.
DAY(A2)-1 does for day.

Regards,

 

[Khalid NGO]

Or:
=EDATE(A2,12)-1

 

[ushaanu]

Or:
=EDATE(A2,12)-1

thank you Khalid it`s working thank a lot

 

[Khalid NGO]

thank you Khalid it`s working thank a lot

Welcome Anu.
Take Care.