Difference between revisions of "Documentation/How Tos/Calc: DAY function"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 11: Line 11:
  
 
=== Example: ===
 
=== Example: ===
<tt>'''DAY("2008/06/04")'''</tt>
+
<tt>'''DAY("2008-06-04")'''</tt>
 
: returns <tt>'''4'''</tt>.
 
: returns <tt>'''4'''</tt>.
  

Revision as of 13:06, 18 January 2008


DAY

Returns the day of a given date.

Syntax:

DAY(date)

returns the day of date as a number (1-31).
date may be text or a date-time serial number.

Example:

DAY("2008-06-04")

returns 4.

DAY(A1)

where cell A1 contains the date 23Nov83 as a date-time serial number, returns 23.

See also:

YEAR, MONTH, WEEKDAY, HOUR, MINUTE, SECOND

Date & Time functions

Date & Time overview

Personal tools