How can I count dates within 90 days?

I want to count how many people are within 90 days of their expiration date if the data is combined across columns from "Exp Date: Pacer" to column "New Exp Date: Walkie/Tugger"? The original formula I tried is the following:

=COUNTIFS([Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, ">" & TODAY(), [Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, "<=" & TODAY() + 90)

I keep receiving an error message. All columns are adjacent to each other, and all are formatted as date columns, though 4 of them within the range have column formulas linked to another column, but all values in the column are dates.

Is there a way to get this data?

Find more posts tagged with

Accepted answers

Carson Penticuff

If I understand correctly, you are very close. Give this a try:

=COUNTIFS([Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, > TODAY(), [Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, <= TODAY(90))

All comments

Carson Penticuff

If I understand correctly, you are very close. Give this a try:

=COUNTIFS([Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, > TODAY(), [Exp Date: Pacer]@row:[New Exp Date: Walkie/Tugger]@row, <= TODAY(90))

David P

Thank you so much Carson. Do not add the 90, put it in the parenthesis.

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.