Extract a value if today is between start and end date

Hi all,

I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha)

I have a schedule with 3 main columns - the name, the start date and the end date. What I was hoping to do was extract who is currently scheduled if today was equal greater than the start date and if today was less than the end date. It seemed easy enough in my head but I may be doing something wrong.

Anyone have any suggestions?

Find more posts tagged with

Contacts

Formulas

functionality

Accepted answers

L_123

Is it possible for overlap?

=join(collect(name:name,[due date]:[due date],@cell <= today(),[end date]:[end date],@cell > today()), ",")

All comments

Ryan Nix

Apologies, here's the formula I was trying to use but it doesn't work:

=INDEX(Name:Name, (MATCH(IF([Due Date]:[Due Date] <= TODAY(), IF([End Date]:[End Date]) > TODAY()), 0)))

L_123

Is it possible for overlap?

=join(collect(name:name,[due date]:[due date],@cell <= today(),[end date]:[end date],@cell > today()), ",")

Amit Wadhwani

Well you can create a new column and apply this formula to that:

=IF(AND(TODAY() >= [Start Date]@row, TODAY() < [End Date]@row), "Name@row", "")

Paul Newcome

@Amit Wadhwani That would only pull the name for that single row. L@123's solution allows the name(s) that meet the criteria to be pulled to the same cell which would keep you from having to scroll the sheet looking for a name.

Ryan Nix

@L@123 That worked! Thank you so much for the help

Appreciate everyone else's input as well :)

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.