How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?

Shawn Curwen

I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. Thanks

Andrée Starå

Hi Shawn,

Try something like this.

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

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Excellent!

Happy to help!

You'd reference the cell with the date that you want to show month name from in another cell.

Make sense?

Andrée Starå

Hi Shawn,

Try something like this.

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

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shawn Curwen

This makes sense. thanks.

I'm trying to implement into a cell. does this (Date@row) reference the cell I'm getting the 1 or 2 or 3... from?

Andrée Starå

Excellent!

Happy to help!

You'd reference the cell with the date that you want to show month name from in another cell.

Make sense?

Shawn Curwen

I tried this formula in Excel and it did not work.

Andrée Starå

@Shawn Curwen The formula is for Smartsheet so it wont work in Excel.

Myra Jane Lim

Hi, thanks so much @Andrée Starå! I tried this in my sheet but it results to #UNPARSEABLE. Any idea why? Thanks!

EDIT: So, this one worked: https://community.smartsheet.com/discussion/comment/262755

Sharing for others' alternative. :)

Andrée Starå

@Myra Jane Lim

Happy to help!

I would need some more information to see why it's not working, but I noticed that you solved it in another way.

akarlsson

I tried this formula with some modifications for my sheet and I am still getting #UNPARESABLE. The formula I used is:

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

The Invoice Date column is a DATE column type. Format is MM/DD/YY.

Any advice?