Formula help

Kelly Ospina

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?

Kurt Mostrom

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)

Kent Vaughn

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())

 

 

 

Kelly Ospina

Thank you!