# countif with dates

• =COUNTIFS({StartDate_Range}, IFERROR(YEAR(@cell), 0) = 2018)

• Thank You so much it worked. Lovely!!!

• Happy to help! • Hi All,

Attempting to count dates to see how many of a specific item has been completed on a specific date.

I am using the below formula =COUNTIFS({Column Rectification Tracking Range 5}, "2018.08.28") but am getting O count

Any idea what I am doing incorrect?

• When referencing a specific date within a formula, you need to use the date function.

=COUNTIFS({Column Rectification Tracking Range 5}, @cell = DATE(2018, 085, 28))

• Hi, trying to do something similar to these, but failing to produce an expected return...

My aim is to use COUNTIF to tally the number of projects that posted in a specific month range.

In the example below I want to reference this master sheet's "Post Date (aka 'posted')" range ... {Visual Content Metrics-posted} and identify just the results at a month/year level... so the expected result of counting post dates in June would be 6 and May would = 15.

I've not had success returning the expected results in the attempts I've made using COUNTIF(S)...

Is there a way to write this formula:

=COUNTIFS({Column Rectification Tracking Range 5}, @cell = DATE(2018, 085, 28))

but return results for a month range, within the posted date range?

=COUNTIFS({Visuals Content Metrics-posted}, [<<< ? >>>])

Thanks very much!

• @Sean Hintz To count for June of 2020 you can use something along the lines of

=COUNTIFS({Other Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = 6, IFERROR(YEAR(@cell), 0) = 2020))

Just change the 6 and 2020 to count for whatever month/year you are wanting to count.

• Hi!

I'm trying to count the number of times a client requested a project within a specific date range.

I was able to do the first part of the formula: counting the amount of times a client's name was registered in my master sheet:

=COUNTIFS({POC Assets count}, POC1)

But the second part of the formula where I want to narrow it down now by date range, is the one I'm having trouble getting it right. The date range can be by month (all of August 2020 for example) or I can use two of the columns in my master sheet: Start date and Due date,

(This formula is using the function: reference to another sheet)

Thank you!

• @Andrea Antillon Which would you prefer, a specific month or a date range?

• Hi,

Is anyone able to identify the issue with the formula I'm using.

=COUNTIFS([2022/07/01]:[2022/12/31], IFERROR(YEAR(@cell), 0) = 2022)

Its purpose count a column that has dates within a certain date range for a summary table. I've done YYYY-MM-DD format and MM/DD/YYYY but I keep getting the same error "#UNPARSEABLE". Thank you!

• @Ammar Zafar Try this:

• @Paul Newcome Thank you!

That one worked perfectly to count the number of dates in a column. If I wanted to create a date range for the formula to count, does the function work the same way?

For example if I wanted to count all the rows with the dates between 07/01/2022 and 12/31/2022, how do I change formula to only count the range of dates given?

Thanks!

• You would use the DATE function inside of an AND as the criteria.

AND(@cell<= DATE(yyyy,mm,dd), @cell>= DATE(yyyy,mm,dd))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!