Anniversary dates

Hi Guys,

Need some assistance with anniversary dates. Its probably something easy, i cant seem to get it to work - or my brain is melting

I am currently using =DAY(D1)&"/"&MONTH(D1)&"/"&YEAR(TODAY())The problem with that is its giving a date with this years year.... i want it to show last years anniversary date & next years date... What is the formulas i should use for this?

Example.... format = dd/mm/yyyy

Start Date	Prev Ann Date	Next Ann Date
20/09/2001	20/09/2012	20/09/2013
22/04/2005	22/04/2013	22/04/2014
1/01/1990	1/01/2013	1/01/2014

Thanks in advance for any replies

If you have a date in A2 then try this formula in B2 for previous anniversary date

=EDATE(A2,DATEDIF(A2,TODAY(),"y")*12)

and then for the next one 12 months on.....

=EDATE(B2,12)

What should previous show if today is the anniversary, this year or last?

Hi Daddylonglegs, it should show this year or todays date.

But..Thank you thank you. thank was so simple.