Hi,

mm is minutes, format to mmm for Month.

Matt


-----Original Message-----
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
.