Check box for start date and end date that fall within Today's date

Hi Community

I have a check box column with a column formula to check if the Start Date and End Date are Todays Date.

=IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0)

This works when there is a date range, ie Start Date is 18/2/26 and End Date is 26/2. However, if Start Date and End Date are the same date ie 19/2, the formula does not work and the check box remains unticked.

Columns for Dates are column type Date.

What am I doing wrong?

Appreciate any assistance!

Find more posts tagged with

Formulas

Accepted answers

AngB789

You could try this.

=IF(OR([Start Date]@row = TODAY(), [End Date]@row = TODAY()), 1, 0)

All comments

AngB789

Are you just looking to check the checkbox if both start and end date are todays date?
or
Are you trying to do that plus check the checkbox if start date or end date is todays date? @April K

April K

second option - because the check box works for when the Start and End dates are different, but not if they are the same date being todays date.

AngB789

Just to confirm your saying you want the checkbox to check if start and end date are the same but also is start date or end date are todays date?

AngB789

You could try this.

=IF(OR([Start Date]@row = TODAY(), [End Date]@row = TODAY()), 1, 0)

April K

So this is what I currently have, using

=IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0)

And you can see that the last entry with the same dates (being today) the box isn't ticked.

I tried your formula below and all the

AngB789

Okay so your looking for it to show that they are on leave on and between those dates?
I hope I am understanding that correctly.

=IF(OR(AND([Start Date]@row = TODAY(), [End Date]@row = TODAY()), AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY())), 1, 0)

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.