• 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

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?
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:
fareedexcel
Isn't this something same as You previous thread?
If so - one thread has to close - which one?
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.
 
Thanks Sumproduct is working perfect. I tried the same logic by adding 0 in countif but im getting an error.
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.
 
Back
Top