View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonas
 
Posts: n/a
Default Date of expiry - warning?

Hi,
could anyone help in how to make a function that warns when a cell contains
a date that has expired due to a predefined timespan?

Basically what I have is a column with dates and I want to create a function
in a second column that warn whenever one of the dates are more then 3 years
old in relation to the current date.

Any suggestions?

All the best
Jonas