Why cant I count in this date range?

RickyT

Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ?

=COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1)))

Anyone help me with the syntax here?

Find more posts tagged with

Formulas

Accepted answers

TVang

Try this...

=COUNTIF([RLO Receive Date]:[RLO Receive Date], AND(@cell>=DATE(2024,1,1), @cell<=DATE(2024,4,1)))

You want both conditions to be true, "greater that or equal to 2024-01-01" and "less than or equal to 2024-04-01", so wrap the criteria within AND().

Also, your original formula had an extra ")".

All comments

TVang

Try this...

=COUNTIF([RLO Receive Date]:[RLO Receive Date], AND(@cell>=DATE(2024,1,1), @cell<=DATE(2024,4,1)))

You want both conditions to be true, "greater that or equal to 2024-01-01" and "less than or equal to 2024-04-01", so wrap the criteria within AND().

Also, your original formula had an extra ")".

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.