Very Simple MONTH Function

Daniel Barrett

Hi All

I know this seems like a waste of a question but I really don't understand why the MONTH function doesn't work

My month is formatted to UK DD/MM/YYYY and I have entered =MONTH([Month]) and it doesn't work and either shows INVALID DATA TYPE or INPARSEABLE

Yep, I know, should be simple but for me... it's not

Thanks for any help

Dan

Neil Watson

Hi

Your formula should look like this: =MONTH(Date@row), as per below:

Also, the formula returns 1 for January, 2 for February etc. so the format of the column where the formula is should be Text/Number.

https://help.smartsheet.com/function/month

Neil Watson

Hi

Your formula should look like this: =MONTH(Date@row), as per below:

Also, the formula returns 1 for January, 2 for February etc. so the format of the column where the formula is should be Text/Number.

https://help.smartsheet.com/function/month

Daniel Barrett

Thanks Neil

I realise I was being a bit daft this morning and the column was actually not formatted in terms of the column but the visual representation of the date in the cell...

So used to spreadsheets doing everything for me!

Lesson learned!

Neil Watson

We all have that!