Totalling Number of Tasks from Dates

I have a sheet with "Date Record created" and the dates are in the usual format 29/07/25 etc. I want to show a graph on a dashboard, how many tasks are from 2024 and how many are from 2025. I have created a new sheet to create the formula but I am getting "Incorrect Argument", please see below:

=COUNTIF({OAP PA Tracker V2 Range 1}, >=DATE(2024 / 1 / 1), <=DATE(2024 / 12 / 31))

Thanks in advance, for your help

Find more posts tagged with

Accepted answers

Paul Newcome

Give this one a try:

=COUNTIFS({OAP PA Tracker V2 Range 1}, IFERROR(YEAR(@cell), 0) = 2024)

All comments

Paul Newcome

Give this one a try:

=COUNTIFS({OAP PA Tracker V2 Range 1}, IFERROR(YEAR(@cell), 0) = 2024)

Amanda O

Hi @Paul Newcome

That worked, thank you so much again:-)

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.