|Subject:||Re: Calculating dates|
|Posted by:||Rick Rothstein (rick.newsNO.SP…@NO.SPAMverizon.net)|
|Date:||Wed, 5 Jan 2011|
Another way involving only one function call...
Rick Rothstein (MVP - Excel)
"Jordon" wrote in message news:ig2a5u$toi$…@news.eternal-september.org...
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.
Calculating dates posted by Jordon on Wed, 05 Jan 2011