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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!