Very Simple MONTH Function

Daniel Barrett · 06/30/21

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 · 06/30/21

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.

MONTH Function | Smartsheet Learning Center

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

Returns a number representing the number of the month, 1-12, where 1 is January.

Neil Watson · 06/30/21

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.

MONTH Function | Smartsheet Learning Center

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

Returns a number representing the number of the month, 1-12, where 1 is January.

Daniel Barrett · 06/30/21

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 · 06/30/21

We all have that!

Formulas and Functions

Formulas and Functions

Very Simple MONTH Function

Best Answer

MONTH Function | Smartsheet Learning Center

Answers

MONTH Function | Smartsheet Learning Center

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA