DAY Function or DAY Formula in Excel with example

DAY Function or DAY Formula in Excel with example

DAY

Returns day from the given date. DAY Function takes one parameter as serial_number which refers to a valid date and returns day back. This day refers to the month from given date which would be between 1 to 31 based on month.

Syntax

=DAY(serial_number)

  • serial_number: refers to a valid date from which a day will be extracted in integer format.

Formula

Output

Next >> Understand YEAR Function in Excel with example

Leave a Reply

Your email address will not be published.