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

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

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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
>
>
>.
>

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/