Re: Calculating dates

Giganews Newsgroups
Subject: Re: Calculating dates
Posted by:  Rick Rothstein (rick.newsNO.SP…
Date: Wed, 5 Jan 2011

Another way involving only one function call...


Rick Rothstein (MVP - Excel)

"Jordon"  wrote in message news:ig2a5u$toi$…

Can anyone tell me what I should use (in the way of helper cells)
to take any date (mm/dd/yyyy) and turn it into that same month
and day for specific year? For instance, turn...

10/12/2009 into 10/12/2010
4/6/1998 into 4/6/2010

I'm trying to determine anniversary date based on start date and
do it starting in 2010.




In response to

Calculating dates posted by Jordon on Wed, 05 Jan 2011