Find middle number using LEFT and RIGHT Formulas

Faisal F

I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10)

Please help, thanks!

Amber Eakin

Hi @Faisal F - Are the dates always YYYY-MM-DD? If so, you can use this (you'll need to substitute your date column name where I've written "Date":

=MID(Date@row, 6, 2)

If they are YYYY-M-D if it's 2023-4-4, for instance, this one will work:

=IF(MID(Date@row, 7, 1) = "-", MID(Date@row, 6, 1), MID(Date@row, 6, 2))

Please let me know if that helps!