Count entries in one month range using UK date format

[keithobro]

I have a spreadsheet with a list of dates in columns. I need to count how many entries in a specific column fall within a specified month. The dates are in UK format (DD/MM/YY). What formula do I need to achieve this count and what if some of the fields do not contain numbers?

 

[Fluff]

How about

=COUNTIFS(D4:D18,">="&DATE(2021,3,1),D4:D18,"<"&DATE(2021,4,1))

 

[keithobro]

How about

=COUNTIFS(D4:D18,">="&DATE(2021,3,1),D4:D18,"<"&DATE(2021,4,1))

Thank you. I tried that and it returned a zero result.

 

[Fluff]

In that case make sure your dates are real dates & not text. Select col D and change the format to numbers, what do you see?

 

[keithobro]

In that case make sure your dates are real dates & not text. Select col D and change the format to numbers, what do you see?

I formatted those cells that were dates to dates and still zero.

 

[Fluff]

Format the date cells to numbers & what do they look like?

 

[keithobro]

Format the date cells to numbers & what do they look like?

15/3/21

15/3/21

FTA

16/3/21

16/3/21

FTA

17/3/21

17/3/21

19/3/21

19/3/21

44290

44290

44321

44321

20/5/21

 

[Fluff]

In that case most of them are text & not dates, you will need to convert them into real dates

 

[Marcelo Branco]

To convert to real dates
Select the values
Data > Text to columns
Next
Next
In the 3rd step pick Date and select DMY
Finish

M.

 

[keithobro]

15/3/21

15/3/21

FTA

16/3/21

16/3/21

FTA

17/3/21

17/3/21

19/3/21

19/3/21

44290

44290

44321

44321

20/5/21