The title may sound easy but the problem might be a little trickier, or
so I think. Col A has a series of dates (mm/dd/yyyy). What I need to
do, but don't know how, is add 1 to the month portion of the dates (eg,
if A1 = 5/13/2005, I need B2 = 6/13/2005; 7/15/2006 -- 8/15/2006). I
know this sounds easy and I can just write the date I want, but I have
thousands of dates that need to be changed. I appreciate all the help
I get. Thank you.


-- Isaac


--
I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
View this thread: http://www.excelforum.com/showthread...hreadid=560191

"I Maycotte" wrote
in message ...

The title may sound easy but the problem might be a little trickier, or
so I think. Col A has a series of dates (mm/dd/yyyy). What I need to
do, but don't know how, is add 1 to the month portion of the dates (eg,
if A1 = 5/13/2005, I need B2 = 6/13/2005; 7/15/2006 -- 8/15/2006). I
know this sounds easy and I can just write the date I want, but I have
thousands of dates that need to be changed. I appreciate all the help
I get. Thank you.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
--
David Biddulph