Very Simple MONTH Function


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


Best Answer


  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer


    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.