How to calculate 12 months from "Date Added" field

  • Thread starter Thread starter Sandi Gauthier
  • Start date Start date
S

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
 
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
 
Back
Top