due date again

  • Thread starter Thread starter GORDON
  • Start date Start date
G

GORDON

I was trying to find a correct formula that would give me due dates.
eg: if column A contains a date or the word NA and column B contain
the formula plus 12 months I would like column B to show either NA o
the new date plus 12 months. The formula I used wa
=DATE(YEAR(A1),MONTH(A1)+12,DAY(A1))

1999-08-12 2000-08-12
NA #VALUE!

Once that formula completes, it should notify me by the 10 month t
send out a notice that it is due on or before the date in column B.
Would the if function work here? I would appreciate any help anybod
can give me. Thanks again
 
Back
Top