Thread: Automatically fill in dates two weeks and one month ahead of date inputted manually

Hi all

I have a log which I am creating, and I need to write a macro/formula to automatically fill in some dates. When I input a date in to Column D, I want Excel to fill in the date two weeks after that in Column K and one month after it in Column L. This is so that I can keep track of when things are due. I have seen it done before on an old spreadsheet I used but I dont have a copy any more... Hope someone can help!

Thanks

As you edited the title.
If your date is given in D1 then

to add two weeks

=D1+14

to add a month

=D1+30

(considering 30 days for one month)

Perhaps this way. See the attachment. Provided, D column contains dates and/or empty cells only (for the macro to run)

This might be more accurate for adding a Month

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

Using Excel 2010 look at Tables for extending the formula, in the example add dates to column A

Right Roy, I just thought this formula may crash at dates like 31/01/2011 as 31/02/2011 is invalid. But it doesn't. I should have tried it. So I too prefer your answer