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 3

Sorry for not explaining the problem better.

With the formula =INT((TODAY()-D10)/365.25);
I get a value of "0" for the first year past todays date, and I can only
have a max value of 4.