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

DAY(serial_number)

 
 Returns the day as an integer given a date serial number.

 serial_numberThe date that contains the day you want 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=DAY(B1) = 101 Jul 2003
    2=DAY("01 July 2003") = 1=NOW() = 31/07/2007
    3=DAY(B2) = 31=NOW() = 39295
    4=DAY(38094) = 17 
    5=DAY(DATE(1977,7,1)) = 1 
    6=DAY(DATEVALUE("01 Jul 2003")) = 1 
    7=DAY(0) = 0 
    8=DAY(-10) = #NUM! 
    9=DAY("some text") = #VALUE! 
    		 
     Functions - D | Index - D | Dates & Times | Office Online 

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