Skip to main content

DAY

Definition of DAY

Returns the day of the month that a specific date falls on, in numeric format.

Sample Usage

DAY(DATE(1969,7,20))

DAY(A2)

DAY(40909)

DAY("7/20/1969")

Syntax

DAY(date)

  • date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATEDATEVALUE or TO_DATE, or a date serial number of the type returned by the N function.

  • DAY does not autoconvert number formats. Therefore, DAY(10/10/2000) is interpreted as DAY(0.005), the quotient of 10 divided by 10 divided by 2000.

  • DAY returns the intuitive understanding of the day of the month, and is useful primarily in other calculations rather than to extract the day of month from a known date, as that value is easily known from reading the entire date.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the DAY formula, start with your edited Excellentable:

Then type in the DAY Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DAY formula for, Excellentable will generate the outcome:

 

A
B
C
D
1
State
Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
4833722
52,420 (135,767)
50,645 (131,170)
3
Alaska
735132
665,384 (1,723,337)
570,641 (1,477,950)
4
Arizona
6626624
113,990 (295,233)
113,594 (294,207)
5
Arkansas
2959373
53,179 (137,733)
52,035 (134,770)
6
California
38332521
163,695 (423,968)
155,779 (403,466)
7
Colorado
5268367
104,094 (269,602)
103,642 (268,432)
8
Connecticut
3596080
5,543 (14,356)
4,842 (12,541)
9
Delaware
925749
2,489 (6,446)
1,949 (5,048)
10
Florida
19552860
65,758 (170,312)
53,625 (138,888)
11
Georgia
9992167
59,425 (153,910)
57,513 (148,958)
12
Hawaii
1404054
10,932 (28,314)
6,423 (16,635)
13
Idaho
1612136
83,569 (216,443)
82,643 (214,044)
14
15
E
F
G
1
Date
2
1,775 (4,597)
7
7/5/2008
3
94,743 (245,383)
1
7/6/2009
4
396 (1,026)
9
7/7/2010
5
1,143 (2,960)
4
7/8/2011
6
7,916 (20,502)
53
7/9/2012
7
452 (1,171)
7
7/10/2013
8
701 (1,816)
5
7/11/2014
9
540 (1,399)
1
7/12/2001
10
12,133 (31,424)
27
7/13/2002
11
1,912 (4,950)
14
7/14/2003
12
4,509 (11,678)
2
7/15/2004
13
926 (2,398)
2
7/16/2005
14
15
DAY:
15

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.