Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / DAY
In This Topic
    DAY
    In This Topic

    Summary

    This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date.

    Syntax

    DAY(date)

    Arguments

    Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

    Data Types

    Accepts numeric, string, or DateTime object data. Returns numeric data.

    Examples

    DAY(A2)

    DAY(R2C1)

    DAY(366778) gives the result 14

    DAY(33239) gives the result 1 (because 33239 is the value for January 1, 1991)

    DAY("7/4/2003 12:00")

    DAY(DATE(2003,7,4))

    See Also