Autopopulating a date


K

KellyJane

I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically give me the date
months from the date in A1. I have another date in C1 and I want t
automatically populate the date 6 months later in D1.

I want to be able to enter different dates in the A column with th
corresponding date to follow in the B column automatically.

Can anyone help
 
Ad

Advertisements

J

joeu2004

KellyJane said:
I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically
give me the date 3 months from the date in A1.

In B2: =EDATE(A1,3).

If you are using Excel 2003, EDATE is part of the ATP, an add-in which must
be installed and enabled.

If you cannot use EDATE, the following is equivalent:

=MIN(DATE(YEAR(A1),3+MONTH(A1),DAY(A1)), DATE(YEAR(A1),4+MONTH(A1),0))
 

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

Top