# 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

• 10.8 KB Views: 9

#### vletm

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

##### Member
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.

#### bosco_yip

##### Excel Ninja
C5 :

=SUMPRODUCT((0+A2:A50>=DATE(2020,1,1))*(0+A2:A50<=DATE(2020,3,31)))

#### fareedexcel

##### Member
C5 :

=SUMPRODUCT((0+A2:A50>=DATE(2020,1,1))*(0+A2:A50<=DATE(2020,3,31)))
Thanks Sumproduct is working perfect. I tried the same logic by adding 0 in countif but im getting an error.

#### bosco_yip

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

#### fareedexcel

##### Member
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

##### Member
Hi Experts. Any solutions for using with Countif function please

#### vletm

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