Can you match a date from a drop down column?

Hi,

I was trying to focus on preventing errors by added a list of very specific dates one can submit requests. I was hoping to have a drop down of dates to choose from. Then I have additional columns that will match that date selected and autofill the rest of the due dates from another sheet.

If the user inputs the date manually, I have a formula that pulls the next column. That formula is:

=INDEX({2025 Dates | AELR Due Dates}, MATCH([Publication | Issue Date]@row , {2025 DSD DATES | Regulation Issue Date 2}, 0))

The drop down column I am test is not a date column, so I am aware that causes some issues. I attempted to add quotations at the end since another user helped me with that previous but it is not working in this instance and AI is not figuring it out for me either. Probably a me issue.

Does anyone know if it is possible to match a date from a drop down column?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Sorry about that. I hit the wrong key. Try this:

=DATE(VALUE("20" + RIGHT([Dropdown Column Name]@row , 2)), VALUE(LEFT([Dropdown Column Name]@row , 2)), VALUE(MID([Dropdown Column Name]@row , 4, 2)))

All comments

Paul Newcome

You would want a helper column t convert it into an actual date. What is the date format in your dropdown column?

Tricia_S

Hi. This is on my intake sheet, which is attached to a form. Can I do a helper column without messing up my incoming submissions?

Format is MM/DD/YY.

Paul Newcome

A helper column will not mess up your existing intake process. Try this formula in a date type column:

=DATE(VALUE("20" _ RIGHT([Dropdown Column Name]@row, 2)), VALUE(LEFT([Dropdown Column Name]@row, 2)), VALUE(MID([Dropdown Column Name]@row, 4, 2)))

The above is assuming all years are post 2000 and all months and days will be zero filled to make them two digits such as "01" instead of just "1".

Tricia_S

Yes, everything is 2025 and up.

The formual gives me an unparseable error.

The column is named testing issue date so this is what I entered:

=DATE(VALUE("20" _ RIGHT([Testing Issue Date]@row , 2)), VALUE(LEFT([Testing Issue Date]@row , 2)), VALUE(MID([Testing Issue Date]@row , 4, 2)))

This is my drop down column settings:

Paul Newcome

Sorry about that. I hit the wrong key. Try this:

=DATE(VALUE("20" + RIGHT([Dropdown Column Name]@row , 2)), VALUE(LEFT([Dropdown Column Name]@row , 2)), VALUE(MID([Dropdown Column Name]@row , 4, 2)))

Tricia_S

Perfection! Thank you

Paul Newcome

Happy to help. 👍️

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.