anniversary dates
You superstar - I would never have got there on my own!
"Ron Coderre" wrote:
Try this:
A1: (Hire date..no future dates, no text)
Next anniversary date:
=IF(A1,TODAY()+LOOKUP(365,--(TEXT(A1,"dd-mmm-")&(YEAR(NOW())+{0,1}))-TODAY()),"")
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"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
|