• 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 dates

fareedexcel

fareedexcel

Member
Hi Experts,

Please help in count the dates. I have correctly mentioned the formula but still i'm not getting the correct result. As the dates are in text format, i tried converting them using Text function but still the count is not working.
 

Attachments

  • Count Checker.xlsx
    10.8 KB · Views: 9
fareedexcel
Isn't this something same as You previous thread?

Count between dates with certain Criteria

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...
chandoo.org
If so - one thread has to close - which one?

Hints:
> A-column should be dates, not text
> formulas 'dates' should be dates too ( or have to format as yyyymmdd )
> sheets calculation should be something else than manual
>> then there could get 5 in cell C5
 
Last edited:
vletm said:
fareedexcel
Isn't this something same as You previous thread?

Count between dates with certain Criteria

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...
chandoo.org
If so - one thread has to close - which one?
Click to expand...
The old thread to be closed. I have made as unwatch and I dont know how to remove that thread as the attachment seems confusing.
 
fareedexcel said:
Thanks Sumproduct is working perfect. I tried the same logic by adding 0 in countif but im getting an error.
Click to expand...
Or, to convert column A "text value" into "numeric value" by :

Select A2:A29 >> Text to Columns >> Finish

then, use this formula :

=COUNTIFS(A:A,">="&DATE(2020,1,1),A:A,"<="&DATE(2020,3,31))

Regards
 
The problem here is I couldn't use Text to columns formula, because the output should be hardcorded. Without manipulating the column I need to count the numbers. Is it possible by using any additional formula along with countif as you did for Sumproduct
 
fareedexcel
You've gotten few already 'Any solutions',
but You would like to use dates as texts.
You can get that output with those and after that copy > paste only values > fixed values.
 
You must log in or register to reply here.
Back
Top