IF/Date formula

[william11]

I need a formula that evaluates a past date (E4) and returns:

0 if less than 12 months
1 when has been 1 year since E4, and during the course of year 1
2 when is has been 2 years since E4, and during the course of year 2
3 and so on...


thanks for any help

 

[Alex0013]

Hello,

I would try something like:

=ROUNDDOWN((TODAY()-E4)/365,0)

This determines the number of days between today and the date in E4, then divides by 365 days. This answer is then rounded down so that anything within a year is 0, during the year of 1 year old 1, etc.

Let me know if this works for you.

Regards,
Alex

 

[juankalsa]

If(
E4<365;0;
E4>365<730;1
E4>730<1096;2
and So On....

 

[william11]

It works, thank you

 

[mfexcel]

would this help?
=DATEDIF(E4,TODAY(),"Y")

I need a formula that evaluates a past date (E4) and returns:

0 if less than 12 months
1 when has been 1 year since E4, and during the course of year 1
2 when is has been 2 years since E4, and during the course of year 2
3 and so on...


thanks for any help