Buzz
This article provides a detailed guide on how to use the DAY Function, which returns the day of a date in Excel.
Description: The function extracts the day value from a date value. It returns an integer from 1 to 31.
Syntax: DAY(serial_number).
In which:
serial_number represents the date from which to extract the day value.
Example:
Extract the day value from the following date values:
Enter the formula DAY(C7) in the cell where you want to calculate.
Press Enter -> to get the separated day value result.
Copy the formula for the remaining values to obtain the results.
In case the month does not have 31 days, you can still input a date containing 31 days -> the function returns the error value #VALUE!.
Here is how to use and some tips when using the DAY function in Excel.
Wishing you all the best!
