Count dates that have expired or due to within 1 month, 3 months etc

Welcome to the forum!

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Formulas:
B21 =COUNTIF(B2:B13,"<"&TODAY()+30)-B20
B22 =COUNTIF(B2:B13,"<"&TODAY()+90)-B20-B21
B23 =COUNTIF(B2:B14,"<"&TODAY()+180)-B20-B21-B22

Copy across to other columns.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Morning - I've been hunting to find a solution to my similar issue;

I've columns of dates and I want to be able to count, in one cell, how many dates are within 30 days of (prior to) today's date and/or have "expired" and on or past today's date

I've tried the above and many more but struggling! I just can't work out the final piece to the jigsaw

Any help is always appreciated! Book6.xlsx

Originally Posted by Wilgoss

Morning - I've been hunting to find a solution to my similar issue;

I've columns of dates and I want to be able to count, in one cell, how many dates are within 30 days of (prior to) today's date and/or have "expired" and on or past today's date

I've tried the above and many more but struggling! I just can't work out the final piece to the jigsaw

Any help is always appreciated! Attachment 825796

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Ok thanks for understanding