How to calculate 12 months from "Date Added" field

[Sandi Gauthier]

hi there...
in one column i have a "date added" field - it is is month/year format
in a second column (entitled "date eligible for removal) - i want to have a
formula that will calculate 12 months from the "date added" field

firstly, am desperately seeking a formula to perform this calculation!
second, what would be the preferred "format" for the "date added" and "date
eligible for removal fields"? ie...Jun-03, 06/03 etc..

appreciate your assistance!
tks!
sandi

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[firebird96]

Sandi

Let's assume we are talking about Column A and Column B.

If you type 11/19/03 in cell A1, then type =A1+365 in cell B1:

The results in B1 will be 11/19/04.

As for the fomatting, I don't think it really matters as the formatting
has no impact on the formula. Since it doesn't seem as though you are
interested in the specific day of the month choose a the following
format: mmm-yy

This will dispaly Nov-03 even though the data is day specific.

Kevin