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.
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,508
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.
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,508
Could you take a screenshot of the data?
 

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

Similar Threads


Top