• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count between dates with certain Criteria

Status
Not open for further replies.

fareedexcel

Member
Hi All,

I need to count between 2 dates (Start Date - Q1 of the Current Year & End Date - Q1 of the Current Year) - 1/1/21 - 31/3/21. The Year should be dynamic as every year the count should be for the respective year but the quarter remains the same. I have 2 scenarios in the attached file.

I have used Countif function but couldn't achieve the desired result. Please help.
 

Attachments

  • Count Between Dates.xlsx
    13.9 KB · Views: 6
Hi,

Have you tried DatedIF ?

=DatedIF(FirstDate,SecondDate,"D")

D stands for Days

You can also replace D with M (month) & Y (year)
 
fareedexcel
Where do You would like to get Your results?
About Q1 - To filter Entity Start Date in Column S of Data Sheet (1-Jan-21 to 31-Mar-21) ... column is empty?
... and Your
EntityStartDate -column should be all dates (even with time) and same format.
 
fareedexcel
Where do You would like to get Your results?
About Q1 - To filter Entity Start Date in Column S of Data Sheet (1-Jan-21 to 31-Mar-21) ... column is empty?
... and Your
EntityStartDate -column should be all dates (even with time) and same format.
In the highlighted area i need the results to be seen. Sorry Column "J" to be Considered. Please find the revised file, with the entity start date format
 

Attachments

  • Count Between Dates.xlsx
    13.9 KB · Views: 5
Status
Not open for further replies.
Back
Top