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

Can some one help me with the following formula?

I need to create a IF formula that will start with the current date "=TODAY"
and count backwards appling a different numeric number for each year.
ie. from today back 365 days=1; from 366 to 730=2; from 730 to 1095=3; from
1095 on =4.