See if a date is with a defined date range

Hello,

I'm trying to create a formula to see if a date with in a date column is within a defined range. It's partly working but the outcome seems to ignore years (returning a result if days/months match) and it dislikes December all together returning nothing.

The formula is - =IF(AND($[Column18]@row >= [Sep 2023]$2, $[Column18]@row < [Oct 2023]$2), "1", "")

Screenshots attached for reference.

Any help would be appraised, thanks

Find more posts tagged with

Accepted answers

All comments

Frank S.

Greetings,

I hope I'm on the right track since the above example is confusing.

If column 18 is a list of dates and the rest of the columns are a specific Month and year, and the goal is to identify which month and year the date in column 18 falls into, then this might help:

=IF(AND(Column18@row Date(2022, ,9,1), Column18@row<= Date(2022,9,30)), "1", "")

Convert to column formula.

Copy the formula to the other columns and update the date range desired for each month and year.

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.