• 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

sillysagar

New Member
Hi,

Have you tried DatedIF ?

=DatedIF(FirstDate,SecondDate,"D")

D stands for Days

You can also replace D with M (month) & Y (year)
 

vletm

Excel Ninja
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

Member
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

Status
Not open for further replies.
Top