DAY function

DAY returns the day of a given date value. The day is returned as a value 1 - 31. You can also enter a negative date/time value.

Syntax

DAY(number)

Example

=DAY(1) returns 31.

=DAY(NOW()) returns the current day.

=DAY(C4) returns 31 if the contents of C4 = 12/31/1901.

Note: The goal is for IBM Docs to be as accurate and as compatible with Microsoft Excel as possible. Therefore, starting from 3/1/1900, or the numeric value greater than 60, there is no difference between the two applications.



Trademarks | IBM Connections wiki