anniversary dates
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))
--
David Biddulph
"Vicki" wrote in message
...
How do I get a date in the past (column a) to show as a due date this year
in
column b? i.e. if they joined the company on 3-dec-98 then I want the
next
column to automatically say that their appraisal is due on 3-dec-07.
THANKS
|