Very Simple MONTH Function

06/30/21
Accepted

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

Best Answer

Answers

  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    Hi

    Your formula should look like this: =MONTH([email protected]), 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.


  • 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 WatsonNeil Watson ✭✭✭✭✭

    We all have that!

Sign In or Register to comment.