# How to extract just the month name from a date

Options
✭✭

Hi all,

I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.

Tags:

## Best Answers

• Answer ✓
Options

SIS,

I see that you shortened the month names but yes that looks great.

Hope this helps!

Heath Hilton

## Answers

• Options

SIS,

Here is the formula that I was able to come up with. You would need to have the formula below in the [Month] column.

=IF(MONTH([Shipped Date]@row) = 1, "January", IF(MONTH([Shipped Date]@row) = 2, "February", IF(MONTH([Shipped Date]@row) = 3, "March", IF(MONTH([Shipped Date]@row) = 4, "April", IF(MONTH([Shipped Date]@row) = 5, "May", IF(MONTH([Shipped Date]@row) = 6, "June", IF(MONTH([Shipped Date]@row) = 7, "July", IF(MONTH([Shipped Date]@row) = 8, "August", IF(MONTH([Shipped Date]@row) = 9, "September", IF(MONTH([Shipped Date]@row) = 10, "October", IF(MONTH([Shipped Date]@row) = 11, "November", IF(MONTH([Shipped Date]@row) = 12, "December"))))))))))))

Here is what it exports on the sheet.

Let me know if it helps.

Hope this helps!

Heath Hilton

• ✭✭
Options

Thanks,

Thanks so much, Heath! I was trying that formula and was getting an error! What is your thought on the formula I'm trying? it is a workaround based on yours.

• Answer ✓
Options

SIS,

I see that you shortened the month names but yes that looks great.

Hope this helps!

Heath Hilton

• Options

How does the formula works if the Shipping date is empty and the formula need to refer to another date field with the same changes from "Month Number -> Month Name".

e.g. use MONTH from [field 1]@row and change it to Name, if error use MONTH from[ field2]@row and change it to Name.

KR Christin

• Employee
Options

You can add an IFERROR statement around the first MONTH function to evaluate if the cell is blank or not. If it is blank, have it look at your second column instead:

=IF(IFERROR(MONTH([field 1]@row), MONTH([field 2]@row))  = 1, "January",

And so on. Does that make sense?

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!