How to extract Month only from Date column format eg. Apr 6, 2021

Janice Phua

Hi All,

I am a novice in Smartsheet Functions and need some help.

How can I extract the month only (i.e. Apr) from Date column format e.g. Apr 6, 2021 in the same Smartsheet?

Thanks.

Janice

Andrée Starå

Hi @Janice Phua

I hope you're well and safe!

You can use =MONTH(Date@row), and if you want to show the month name, you can use the below formula for that. Otherwise, it will show as a number.

=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"))))))))))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or 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!

Bassam Khalil

Hi @Janice Phua

Hope you are fine, please use this formula

=MONTH(Date@row)

Andrée Starå

Hi @Janice Phua

I hope you're well and safe!

You can use =MONTH(Date@row), and if you want to show the month name, you can use the below formula for that. Otherwise, it will show as a number.

=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"))))))))))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or 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!

Janice Phua

Thanks @Bassam.M Khalil.

Hi @Andrée Starå,

Thank you for the formula, could you provide me steps what I am to do with it? Copy and paste does not work for me 😅. Do I need to create a new column or etc.? Thanks in advance for the guidance!

=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"))))))))))))

Janice Phua

Hi @Andrée Starå - after pondering on the formula - I manage to get it resolved by changing semi-colon to a comma. It works, thanks!

Andrée Starå

@Janice Phua

Excellent!

You're more than welcome!

Have a fantastic weekend!

CricketCO

Can you tell me what we are doing wrong here? We are getting an unparseable message.

Genevieve P.

Hi @CricketCO

There are two Month functions that are missing their opening parentheses (

For example, you have

MONTH[cell reference...

when they should be

MONTH([cell reference

I've underlined the two areas in your formula below:

As another note, I would suggest replacing all of the row references (the 1 after the [date]) with @row instead. This will allow you to turn it into a Column Formula:

MONTH([Email Send Date]@row)

See: Create Efficient Formulas with @cell and @row & Use column formulas to apply calculations to all rows in a sheet

Cheers,

Genevieve

Kpennington

Hi There!

I have tried this formula with both brackets and parenthesis.

Ex: IF(MONTH((Date Submitted)@row)=1 and IF(MONTH([Date Submitted]@row) = 1

With both of these I am getting unparseable. Is there something I am missing?

Genevieve P.

Hi @Kpennington

Your second version of the syntax is the correct one:

IF(MONTH([Date Submitted]@row) = 1

Column names should be wrapped in square brackets, like so:

[Column Name]@row

I also notice that you have a ; (semi-colon) instead of a , (comma) after the 6 in your formula. You'll need to change that out as well!

Let me know if that fixed it for you.

Cheers,

Genevieve

Kpennington

That was it! It was the semi-colon. Thank you.

ErinHell

Ok tried this formula. Change the ; to , and referenced my date field but I am getting an #INVALID Data Type. Help!

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

Paul Newcome

@ErinHell Did you double check that the [Go Live Projection] column is set as a date type column? If so, how exactly is it being populated?

ErinHell

@Paul Newcome that was the problem it was a text field. Thank you!!!!!

ErinHell

@Paul Newcome do you know if there is an iferror statement I can add to blank out fields where it doesn't apply?

Paul Newcome

@ErinHell Yes there is.

=IFERROR(orignial_formula, "")