Re: Calculating dates

Giganews Newsgroups
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...

=--TEXT(A5,"m/d/""2010""")

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
and
4/6/1998 into 4/6/2010

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

TIA

--
Jordon

Replies

In response to

Calculating dates posted by Jordon on Wed, 05 Jan 2011