Documentation/How Tos/Calc: DAY function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 07:30, 17 July 2018 by
Sancho
(
Talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Jump to:
navigation
,
search
CALC FUNCTIONS
Date & Time Functions
FUNCTIONS
Today
Now
Year
Month
Day
Weekday
Hour
Minute
Second
Date
Datevalue
Time
Timevalue
Eomonth
Edate
Workday
Networkdays
Days
Days360
Daysinmonth
Daysinyear
Weeks
Weeksinyear
Weeknum
Weeknum_add
Months
Years
Isleapyear
Eastersunday
Yearfrac
< Previous Page
Next Page >
Contents
1
DAY
1.1
Syntax:
1.2
Example:
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 overview
Date & Time functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Date and Time functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information