View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tlbailey79 tlbailey79 is offline
external usenet poster
 
Posts: 3
Default Need to know formula to make expire in a year.

I was asked if I could create a spreadsheet where we could keep track of
vendors and when they took the safety training for our company. The training
is only good for one year. So I would have a date field. Then I was asked
if I could make it so a year from now the text would change color or
something, to let them know that the safety training had expired. Is there
some sort of formula or function that I could use for this?