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

Kelly.T

Hi There!

I am getting unparseable with this formula. Is there something I am missing?

Thank you!😊

Genevieve P.

Hey @Kelly.T

It looks like you're missing one MONTH function before "11 November"...

"10 October", IF(MONTH([Departure Date]@row) = 11, "11 November",

Also double check that your column name is correctly spelled in each reference 🙂

Kelly.T

Hi @Genevieve P.

Thanks for pointing out.

I still getting unparseable errors after adding the month of November and check the spelling.

Genevieve P.

Hi @Kelly.T

I also see that there's a space between MONTH and the ( at the very start of your formula. Look through and make sure all of the MONTH functions are paired with their opening parentheses.

For example, this will error:

MONTH (

but this will not

MONTH(

Let us know if this works for you, now!

Cheers,

Genevieve

Kelly.T

Hi @Genevieve P.

Yes, I delete everything and retype the formula. It works for me now.

Thanks a lot, Genevieve.

Ryan Reeves

I am getting an error everytime. I keep trying what has worked for others but I must be missing something.

Paul Newcome

@Ryan Reeves You should be using either commas OR semi-colons in between sections whereas you are using both.

=IF(MONTH(Date@row) = 1, "January", IF(.....

or

=IF(MONTH(Date@row) = 1; "January"; IF(.....

Depending on your region. Not both.

Ryan Reeves

Paul, changing the semi-colons out for commas worked. Thank you.

Paul Newcome

@Ryan Reeves Happy to help. 👍️

simonvodo

Hi all, I keep trying the below. I have changed the semi-colons, commas etc but I am still getting #UNPARSABLE. Can anyone see where I am going wrong?

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

Thanks so much for any advice

Genevieve P.

Hey @simonvodo

I notice you're referencing your "Grand Open Date" column with a square bracket on one side and a curly one on the other. You'll need to change all references to have [two square] ones!

So from

MONTH([Grand Open Date}@row)

to

MONTH([Grand Open Date]@row)

Cheers,

Genevieve

JLK

I'm also struggling. I've checked my brackets, my commas, but I still must be missing something because it is still unparsable....

Genevieve P.

Hey @JLK

Looks like you have an extra [Event Date]@row reference in a place that it shouldn't be:

Let us know if removing this has helped!

Cheers,

Genevieve

JLK

Hmm... now I'm getting #Incorrect Arguement Set

Paul Newcome

https://community.smartsheet.com/discussion/comment/401946#Comment_401946

You're missing the "value if error" portion. Go just inside the very last closing parenthesis, enter a comma, then enter the output for when there is no date.