IF or IFS statement

[FanofExcel18]

I am trying to bucket the amount of days something has been open.
Example:
1. 6/5/2018 = 30 or Less
2. 5/5/2018 = 30-60
3. 4/5/2018 = 60 or More

My results have been only 30 or Less when I do have others that fall into 30-60.

=IFS(W2>=TODAY()-30,"30 or Less",W2>=TODAY()-31,"30-60",W2=TODAY()-60,"30-60",W2<today()-61,"60 or="" more")=""

Any help is greatly appreciated!</today()-61,"60>

 

[wideboydixon]

Re: IF or IFS statement - Need help!

Book1
	A	B
1	6/5/2018	30 or Less
2	5/5/2018	30-60
3	4/5/2018	60 or more
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A1>=TODAY()-30,"30 or Less",IF(A1)-60,"60 or more", "30-60"))

WBD

 

[FanofExcel18]

Re: IF or IFS statement - Need help!

Lifesaver thank you!