IF Formula

G

Guest

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
 
D

Don Guillett

More info would have been helpful. Is this what you want.
=INT((TODAY()-H20)/365.25)
 
J

JE McGimpsey

One way:

If you're not concerned about leap years:

A1: <date>

B1: =INT((A1-TODAY()-1)/365)+1

or if your max is really 4:

B1: =MIN(4, INT((A1-TODAY()-1)/365)+1)

If you want to take leap years into account:

B1: =DATEDIF(TODAY(),A1-1,"y")+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formaulating in Execel 4
if formula 5
IF Formula take 2 3
How do I show a specific date! 1
Ignore blank cells when calculating date for If, Then function 2
I am trying to create a formula 1
IIF Statement to return multiple values for a field - JohnW 3
Calculating to add years - including leap year 4

Top