Hello I am trying to create a formula that returns a specific date when a dropdown selection is made

Attilio

class requested	start date
Jan 13, 2025 - July 14, 2025 Oconomowoc, WI
Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site)
Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY
Mar 24, 2025 - Sept 22, 2025 Fontana, CA
Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI
May 13, 2025 - Nov 17, 2025 Huntsville, AL
Jun 16, 2025 - Dec 15, 2025 Amsterdam, NY
Jul 28, 2025 - Feb 22, 2026 Fontana, CA
Aug 25, 2025 - Mar 2, 2026 Oconomowoc, WI
Sep 22, 2025 - Mar 30, 2026 Huntsville, AL
Oct 20, 2025 - Apr 27, 2026 Amsterdam, NY

AravindGP

Hi @Attilio

If you're trying to get the date shown in the class requested column, you will need to have three helper columns. One to capture the month, which you can get using

=IF(LEFT([class requested]@row, 3) = "Jan", 1, IF(LEFT([class requested]@row, 3) = "Feb", 2, IF(LEFT([class requested]@row, 3) = "Mar", 3, IF(LEFT([class requested]@row, 3) = "Apr", 4, IF(LEFT([class requested]@row, 3) = "May", 5, IF(LEFT([class requested]@row, 3) = "Jun", 6, IF(LEFT([class requested]@row, 3) = "Jul", 7, IF(LEFT([class requested]@row, 3) = "Aug", 8, IF(LEFT([class requested]@row, 3) = "Sep", 9, IF(LEFT([class requested]@row, 3) = "Oct", 10, IF(LEFT([class requested]@row, 3) = "Nov", 11, IF(LEFT([class requested]@row, 3) = "Dec", 12))))))))))))

One to capture the date, which you can get using

=VALUE(MID([class requested]@row, 5, 2))

One to capture the year, which you can get using

=VALUE(MID([class requested]@row, 9, 4))

Once you have the three columns with values, you can use this formula in your start date column =DATE([Year helper column]@row, [Month helper column]@row, [Day helper column]@row)

AravindGP

Hi @Attilio

If you're trying to get the date shown in the class requested column, you will need to have three helper columns. One to capture the month, which you can get using

=IF(LEFT([class requested]@row, 3) = "Jan", 1, IF(LEFT([class requested]@row, 3) = "Feb", 2, IF(LEFT([class requested]@row, 3) = "Mar", 3, IF(LEFT([class requested]@row, 3) = "Apr", 4, IF(LEFT([class requested]@row, 3) = "May", 5, IF(LEFT([class requested]@row, 3) = "Jun", 6, IF(LEFT([class requested]@row, 3) = "Jul", 7, IF(LEFT([class requested]@row, 3) = "Aug", 8, IF(LEFT([class requested]@row, 3) = "Sep", 9, IF(LEFT([class requested]@row, 3) = "Oct", 10, IF(LEFT([class requested]@row, 3) = "Nov", 11, IF(LEFT([class requested]@row, 3) = "Dec", 12))))))))))))

One to capture the date, which you can get using

=VALUE(MID([class requested]@row, 5, 2))

One to capture the year, which you can get using

=VALUE(MID([class requested]@row, 9, 4))

Once you have the three columns with values, you can use this formula in your start date column =DATE([Year helper column]@row, [Month helper column]@row, [Day helper column]@row)

Attilio

Hello @AravindGP

Thank you for the response this helps. i can get this formula to work

=IF([Class Requested]@row = "Jan 13, 2025 - July 14, 2025 Oconomowoc, WI", "1/13/25")

and it will display the date i want it to which is 1/13/25, so i guess my issue is how to put together multiple if statements so if someone selected one of the 11 choices from class requested it shows the start date i specified since the dates will not change. so if someone selected " Oct 20, 2025 - Apr 27, 2026 Amsterdam, NY" it would show "10/20/25" in the start date column. Thank you!