Formula help......Please?

  • Thread starter Thread starter swmasson
  • Start date Start date
S

swmasson

Hello everyone,

Can someone please help with this problem i am facing?

I am trying to create a formula that does the following:-

If cell 'A' (Which is a date) is equal to or less than 12 months fro
today = 1, if Cell 'A' is between 12 months to 18 months = 2, if cel
'A' is between 18 to 24 months = 3, if Cell 'A' is greater than 2
months = 4.


Any help would be greatly appreciated.

Thank you very much

Best regards

Swmasso
 
I'm sure someone can come up with a more elegant way of achieving this
result, but I was able to come pretty close with this formula. If the date
is in cell A2 put this formula in B2.
=IF(A2<TODAY()+(12*30),1,IF(A2<TODAY()+(18*30),2,IF(A2<TODAY()+(24*30),3,4))
)

Carlos
 
One way

=IF(OR(A1="",TODAY()<A1),"",VLOOKUP(DATEDIF(A1,TODAY(),"M"),{0,1;13,2;19,3;2
5,4},2))


if you want 18 to return 3 change the 19 to 18

Regards,

Peo Sjoblom
 
Back
Top