I am working on a date Formula and I was able to get Feb, but it's not working for the other months?

amccue121

I am putting together a KPI for my customer. I have to put how many PTD's we have for each month. The month of Feb. is working but I can not get the other months to work and could use some help.

David Tutwiler

Can you post the formula you currently have that is working?

amccue121

=COUNTIFS([Estimated PTD]:[Estimated PTD], >=DATE(2023, 2, 1) <= DATE(2023, 2, 28))

David Tutwiler

If you're just concerned with the month, you could use:

=COUNTIF([Estimated PTD]:[Estimated PTD], IFERROR(MONTH(@cell),0) = 2)

That should work for February, and you should only have to change the month number (ie 2) to get other months to work.

amccue121

Correct, and I have been doing that for March and April changing the month and it's not adding up correctly.

David Tutwiler

Then I would check your column type and also make sure there aren't any formatting issues with any of the dates you currently have in your column. Otherwise, that formula should work correctly.

If the checkbox "Restrict to dates only" is not checked in the column settings then you could potentially have entries that are not correctly formatted as dates, which would throw your counts off.