countif with dates

Paul Newcome

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

Jose Munoz

Thank You so much it worked. Lovely!!!

Paul Newcome

Happy to help! 

A.Luc

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?

Paul Newcome

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))

Sean Hintz

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!

Paul Newcome

@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.

Andrea Antillon

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)

Can you please help me?

Thank you!

Paul Newcome

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

Ammar Zafar

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!

Paul Newcome

@Ammar Zafar Try this:

=COUNTIFS([Date Added]:[Date Added], IFERROR(YEAR(@cell), 0) = 2022)

Ammar Zafar

@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!

Paul Newcome

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

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

Ammar Zafar

@Paul Newcome Thank you for help!!

Paul Newcome

@Ammar Zafar Happy to help! 👍️