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()-C...
Does this do what you want?
=IF(D2="", "Over " & FLOOR(TODAY()-C2, 30) & " days old", "")