Excel Tutorial – DAY

The DAY function in Microsoft Excel is a function that extracts the day of the month from a date. This can be useful if you want to perform calculations based on the day of the month or if you want to extract specific days from a list of dates.

To use the DAY function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the DAY function.
2. Type “=DAY(” into the cell, followed by the cell reference or date that you want to extract the day from. For example, if you want to extract the day from the date in cell A1, you would type “=DAY(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the day of the month.

Here’s an example of how you can use the DAY function in a formula:

=IF(DAY(A1)=1, “First day of the month”, “Not the first day of the month”)

In this example, the DAY function is used to extract the day of the month from the date in cell A1. The IF function then checks if the day is the first day of the month and displays “First day of the month” if it is, or “Not the first day of the month” if it is not.

You can also use the DAY function in conjunction with other date functions, such as the MONTH and YEAR functions, to extract the month and year from a date. For example:

=MONTH(A1)&”/”&DAY(A1)&”/”&YEAR(A1)

This formula would extract the month, day, and year from the date in cell A1 and combine them into a new date in the format “mm/dd/yyyy”.