Countif numbers of dates in a column between two dates

Hello,

I'm trying to automatically calculate the number of dates (in another sheet) which are between two dates in my master data sheet. I can use the COUNTIF function to find the number of dates on/after my first date using the following function:

=COUNTIF({Enquiry Tracker - Date Raised Column}, >=[Reporting To (Week Ending)]@row)

However, I want to calculate the number of dates in the same list between two 'Reporting To' dates i.e. Fri 11-Jun-2021 and Fri 25-Jun-2021.

Can anyone please help me out?

I've tried using nested COUNTIF and AND functions but I just keep getting an error message.

Find more posts tagged with

Accepted answers

Stephen Barnett

Hey everyone - thanks for your feedback on my issue and finally got a working solution based on some of the ideas above.

Have to say this is a great community for sharing ideas/solutions between everyone. 😀

All comments

Paul Newcome

You will need to use a COUNTIFS (with the S on the end). Then you can incorporate more than one range/criteria set. In this particular case, you would specify the same range, but then you would adjust the criteria to be the other end of the date range.

Alejandro Ortega

Hey Stephen,

I believe one way of doing this is using COUNTIFS function instead of countif, i see you were trying to use AND conditional, COUNTIFS have the AND operator implicitly so your formula should look something like this one:

=COUNTIFS({Date}, >=DATES@row, {Date}, <DATESEND@row)

{Date}- Would be the range where you are keeping your reporting dates.

On my mind if you want to know how many dates you have in a date range i would recommend to have two different columns with the start date of the range and the end date of the range, please see the below picture, i hope this help, please let me know if it doesn't.

Thanks

Stephen Barnett

Hey everyone - thanks for your feedback on my issue and finally got a working solution based on some of the ideas above.

Have to say this is a great community for sharing ideas/solutions between everyone. 😀

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.