Formula that returns true/false if today's date falls between two dates on my sheet?

I am trying to write a formula that returns true/false when today's date falls between a date range on my sheet. I want the formula to return "true" if today's date falls between "Start Date" and "End Date."

Below is my current formula, but I continue get a returned value of "#DATE EXPECTED."

=IF(AND(TODAY() >= [Start Date]1, TODAY() <= [End Date]1), true, false)

Any suggestions you have as to how I can make this formula work would be helpful. Thank you!

Find more posts tagged with

Formulas

Accepted answers

L_123

You have a date column and are attempting to output boolean data. You need to output text in order for this to work, and to output text you put quotes around what you want to return.

=IF(AND(TODAY() >= [Start Date]1, TODAY() <= [End Date]1), "true", "false")

Paul Newcome

Or you could change the column to either a text/number type or a symbol type that runs on true/false values such as single star, flag, or checkbox.

All comments

L_123

You have a date column and are attempting to output boolean data. You need to output text in order for this to work, and to output text you put quotes around what you want to return.

=IF(AND(TODAY() >= [Start Date]1, TODAY() <= [End Date]1), "true", "false")

Paul Newcome

Or you could change the column to either a text/number type or a symbol type that runs on true/false values such as single star, flag, or checkbox.

Tayler Schlottman

Thank you both so much! Both answers were very helpful and worked! :)

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.