Monthend with YYYYMM input

[jaymerry]

Hello all,

I'm trying to use the Monthend() function with YYYYMM input. I don't really if it's something possible, as this function expect a complete Date format. Have you any ideas ?

Thanks for your help,

Jaymerry

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

The following should work:

=MonthEnd(Date(Date#('201101', 'YYYYMM')))

Hope that helps.

[jaymerry]

Thank you very much,

It works,

Jaymerry