Adding a month to a date

I

I Maycotte

The title may sound easy but the problem might be a little trickier, o
so I think. Col A has a series of dates (mm/dd/yyyy). What I need t
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).
know this sounds easy and I can just write the date I want, but I hav
thousands of dates that need to be changed. I appreciate all the hel
I get. Thank you.


-- Isaa
 
D

David Biddulph

I Maycotte said:
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.
Click to expand...

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
 
Top