FanofExcel18
Board Regular
- Joined
- Jun 7, 2018
- Messages
- 65
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>
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>