Thread: IF Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default IF Formula

Take 2..

I am trying to get a formula that will assign a numeric value for a each
year past "TODAY". The TODAY date needs to change every day.

Today to 365days=1; 366 days to 730=2; 730 to 1095=3; 1095+ =4