Countif/Sum adding 2 dates

Patti2023

I am trying to count how many leases are signed between two dates (i.e 1/1/2024 to 3/31/2024). This is the formula I am using

=COUNTIFS({STORE WORKING FILE Range 1}, >=DATE(1 / 1 / 2024), {STORE WORKING FILE Range 1}, <=DATE(3 / 31 / 2024))

Store working file Range 1 = Lease Signed Date

I am getting an incorrect argument. Any thoughts

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @Patti2023,

Your syntax for the DATE function is incorrect. The syntax is DATE(year, month, day).

Hope this helps,

Dave

Patti2023

THANK YOU!!!!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.