Excel formula help please

Poodle

Just cannot remember the formula, a sign of age i guess.

I want to put a date into cell A1

and in A2 I want a formula to add on a date 6 months and 10 days after the date in A1

Thanks

Julia

burg

I'm sure there are a few ways but I use

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)+10)

oakley

format cells A1 and A2 to date
Enter date eg 01/01/2009 in cell A1
enter +A1+190 in cell A2
answer = 10/07/2009

blobbyh

If you expand on Burg's formula by having separate input boxes for 'Month' and 'Day', you can quickly find the date of anything you want by entering months, days or a combination of both.

Target cell formula "=DATE(YEAR(A3),MONTH(A3)+B7,DAY(A3)+D7)"

A3 - the start date
B7 - the number of months
D7 - the number of days

Poodle

Thanks as always