Thread: Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rich rich is offline
external usenet poster
  
Posts: 6
Default Month
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
Reply With QuoteReply With Quote