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

Please Login or Register  to view this content.

to add a month

Please Login or Register  to view this content.

(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