View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rwpatter1 rwpatter1 is offline
external usenet poster
 
Posts: 2
Default excel 2003 date notification formula

I need a formula that will return a notification in a cell that is 1 year
from the selected start date.

I have an employee due a review 1 year from his start date. lets say it is
01/02/09
on 01/02/10 I need an adjacent cell to alert me with the word "DUE"
otherwise it should say "current" it also can be color coded as in
conditional formating
--
William