Forum Discussion
Grouping numbers in 30 day increments
Hello wonderful excel community. I am looking for some help creating a forumla to do the following in column F.
The current formular I am using seems to be rounding up: =IF(D2="",LOOKUP(TODAY()-C2,{0,30,60,90,120 etc}, {"Over 30 days old", "Over 60 days old","Over 90 days old", "Over 120 days old"etc]}),"")
Thank you in advance for your help!
Does this do what you want?
=IF(D2="", "Over " & FLOOR(TODAY()-C2, 30) & " days old", "")
