Skip to main content
Version: Streamsheets 2.5

DAY

Returns the day of the month of the serial number.

Syntax

=DAY(DateValue, [Round])

Arguments

NameTypeDescription
DateValueNumberThe serial number consists out of two numbers. The number to the left of the decimal define the days since 01.01.1900. The number to the right of the decimal define the fraction of the day.
Round (optional)BooleanDefines if value should be rounded. Default is true.

Return

Day of month evaluated from serial number.

Examples

FormulaResultComment
=DAY(43238)
18The given date value represents the 18th of May, 2018
=DAY(43930.999999, true)
10Rounded to 10
=DAY(43930.999999, false)
9Same input value as before but no rounding applied