I have a date column for bid due dates. I'm trying to create a formula that gives me a count of how many rows have a due date coming up in the next 30 days. So far nothing we've tried has worked, not sure why. Does anyone here have a suggestion?
I had trouble with this also due to the column types. I used a DATE column (I called Next 30)to get your =TODAY() + 30 to work. Then in another column =COUNTIF(Due_Date:DueDate,>[Next 30]1)
I just ran a quick test and this seemed to work. It's checking to ensure is between TODAY and TODAY+30.
=COUNTIFS(BidDueDate:BidDueDate, <=(TODAY() + 30), BidDueDate:BidDueDate, >=TODAY())
Thank you!
