Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > MONTH
 

MONTH(serial_number)

 
 The month of a date given a serial number.

 serial_numberThe date that contains the month you are trying to find.

 REMARKS
 
  		• The "serial_number" can be a date, value, cell reference or a text string in a date format.
     
  		• If "serial_number" < 0, then #NUM! is returned.
     
  		• If "serial_number" is not a valid date, then #VALUE! is returned.
     
  		• You can obtain the serial number from a date by using the DATE() function.
     
  		• You can use the DATEVALUE() function to return the serial number representing a date in text format.

     EXAMPLES
     
     AB
    1=MONTH(B1) = 701 Jul 2003
    2=MONTH("01 Jul 2003") = 7=NOW() = 31/07/2007
    3=MONTH(B2) = 7=NOW() = 39295
    4=MONTH(38094) = 4 
    5=MONTH(DATE(1977,7,1)) = 7 
    6=MONTH(DATEVALUE("01 Jul 2003")) = 7 
    7=MONTH(0) = 1 
    8=MONTH(-10) = #NUM! 
    9=MONTH("some text") = #VALUE! 
    		 
     Functions - M | Index - M | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top