Wednesday, January 30, 2013


Function Name

DAY


Syntax

DAY(number)


Description

Returns the day, as an integer, of the given date value. A negative date/time value can be entered. Number is a time value.

Example:


=DateValue("31/01/2013") = 41305


Google Day Function Example
A B
1 Date 41305
2 Formula =Day(B1)
3 Result 31


No comments:

Post a Comment