Countif

Joined
May 26, 2018
Messages
2
Reaction score
0
I am trying to count dates that are approaching a due date within the next 30 days, I have tried multiply ways but am just forgetting something. Any help would be greatly appreciated.
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
So you have a list of dates and you want to count how many fall within the next 30 days? You can use this formula for that:

=COUNTIF(A1:A10,"<"&(TODAY()+30))

Just replace A1:A10 with your range and you're good to go :)
 
Joined
May 26, 2018
Messages
2
Reaction score
0
Thank you Becky, that is one of the several ways I tried and it doesn't seam to work. It is counting everything in the column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top