Hi
don't format the cell as MM. just format the cell as 'Number' or
'General'

--
Regards
Frank Kabel
Frankfurt, Germany


Rich wrote:
I am using

=MONTH(H6)

and have the format of the cell set to mm the value is
stuck at 01 and I cannot understand why.

=YEAR(H6) works fine.

Many Thanks