How do I take a column of dates and add six months?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

Thanks

Mike
 
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

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
 
Or you could use the formula =EDATE(A1,6) which will produce the same result.

/Marcus
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to add six months to date 3
use month in cell date to sum all relevant cells 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Dates and IF Functions 1
formatting a spreadsheet help 4
SUMIF 1
How calculate exact # of months between two dates? 9
Automatic filling of cells within a certain date range 1

Back
Top