Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I take a column of dates and add six months?
0 views
Skip to first unread message
tigerswilson
Jul 25, 2005, 11:22:05 AM7/25/05
to
In Excel 2000 I have a column of dates. I need to know what all the dates
are when 6 months is added to them. How can I achieve this?
are when 6 months is added to them. How can I achieve this?
Thanks
Mike
N Harkawat
Jul 25, 2005, 12:00:45 PM7/25/05
to
insert a new column next to it say column B assuming your column of dates
are in column A
in cell B1 type
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
and copy and paste all the way down in column B
are in column A
in cell B1 type
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
and copy and paste all the way down in column B
it adds 6 months to the current date and if that happens not to be a date
then adjusts it upwards accordingly
Hence Aug-31-99 + 6 months =
Mar-2-2000
"tigerswilson" <tigers...@discussions.microsoft.com> wrote in message
news:BD01450E-6FB5-4DA4...@microsoft.com...
Marcus Langell
Jul 26, 2005, 1:28:01 AM7/26/05
to
Or you could use the formula =EDATE(A1,6) which will produce the same result.
/Marcus
0 new messages