|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
> 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
Shikata ga nai...
Calculating dates posted by Jordon on Wed, 05 Jan 2011