Less than or equal to 30 days from today

Dustin Jenkins

Hello,

I'm trying to figure out how to finalize this formula to be correct but I'm having issues. I want it to count if the date from another sheet is less than or equal to 30 days from today. However its counting dates prior today. I feel like its something simple im missing but just need some help. See formula below.

=COUNTIF({Field Operations Proposals Range 2}, <=DATEONLY(TODAY(30)))

AravindGP

Hi @Dustin Jenkins

You can use this formula

=COUNTIF({Field Operations Proposals Range 2}, <=TODAY(30))

Dustin Jenkins

Aravind,

Thank you for your response. I have tried that one as well and get the same result as the one i posted originally. I've tried several other variations as well and got a similar result.