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

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 61: Line 61:
 
: where cell A1 contains the date <tt>'''23Nov83'''</tt> as a date-time serial number, returns <tt>'''23'''</tt>.
 
: where cell A1 contains the date <tt>'''23Nov83'''</tt> as a date-time serial number, returns <tt>'''23'''</tt>.
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: YEAR function|YEAR]]
 
* [[Documentation/How_Tos/Calc: YEAR function|YEAR]]
 
* [[Documentation/How_Tos/Calc: MONTH function|MONTH]]
 
* [[Documentation/How_Tos/Calc: MONTH function|MONTH]]

Revision as of 07:30, 17 July 2018

CALC FUNCTIONS
< {{#switch:Previous Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >
< {{#switch:Previous Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >



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.



{{#switch:EN

| RU = Смотрите также: | UA = Дивіться також: | EN = See Also | PT = Ver também | #default = See Also }}

Personal tools