DAY
Formulas / DAYRetrieve the day as a number from a date.
=DAY(date)
- date - required
Examples
=DAY(A1)The DAY function is used to extract the day number from a date and display it in a cell. For example this formula would extract the day number from the date in cell A1 and display it in the cell in which the formula is entered.
=DATE(2020,MONTH(A1),DAY(A1))The DAY function can also be used to feed the day value into the DATE function to change the year of a date, but leaving the month and day as-is. For example, this formula would feed the day value from cell A1 into the DATE function, which would then change the year to 2020, but keep the month and day unchanged.
=DAY(A2)-DAY(A1)The DAY function can also be used to calculate the number of days between two dates. This example would calculate the number of days between the dates stored in cells A1 and A2.
=DAY(A2)-DAY(A1)/30The DAY function can also be used to calculate the number of months between two dates. For example this would calculate the number of months between the dates stored in cells A1 and A2.
Summary
The DAY function in Sourcetable allows users to return the day of the date entered as a number. It requires an argument of a date, which should be entered using the DATE function, as Sourcetable calculates dates using sequential serial numbers.
- The DAY function takes a date argument as the required input.
- The date argument must be a valid Sourcetable date, otherwise the function will return #VALUE!.
Frequently Asked Questions
What is the DAY function?
What does the DAY function take as an argument?
What is the serial number?
How does Sourcetable calculate dates?
Can the DAY function return dates entered as text?
What format does the DAY function output?
