Thread
:
IF Formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
IF Formula
More info would have been helpful. Is this what you want.
=INT((TODAY()-H20)/365.25)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Matt" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett