Re: Calculating dates

Giganews Newsgroups
Subject: Re: Calculating dates
Posted by:  Stan Brown (the_stan_bro…@fastmail.fm)
Date: Wed, 5 Jan 2011

On Wed, 05 Jan 2011 09:35:56 -0800, Jordon wrote:
>
> 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.

Suppose the original date is in A1 and the desired year is in B1.
Then your formula is

=DATE( B1, MONTH(A1), DAY(A1) )

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
                                  http://OakRoadSystems.com
Shikata ga nai...

Replies

None

In response to

Calculating dates posted by Jordon on Wed, 05 Jan 2011