Calculating dates

Giganews Newsgroups
Subject: Calculating dates
Posted by:  Jordon (jord…@REMOVE~THISmyrealbox.com)
Date: Wed, 05 Jan 2011

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