DAY Function in Excel

For example, suppose in the spreadsheet, in column A, we have a date of 15-Apr-2015, and we need to extract the day from the date in column B. In such a situation, we can use the DAY function in Excel. Using the function will return the value as 15 in column B.

Syntax

  • Date_value/serial_number: A valid Excel date with the serial number format for returning the day of the month.Return Value: The return value will be a numeric value between 1 and 31, representing the day component in a date.

Usage Notes

  • The date inserted in the DAY formula must be a valid Excel date in the serial number format. For example, the date to be entered is Jan 1, 2000. Therefore, it is equal to the serial number 32526 in Microsoft Excel.We should also note that Microsoft Excel can only handle dates after 1/1/1900.The DAY formula in Excel is helpful in financial modelingFinancial ModelingFinancial modeling refers to the use of excel-based models to reflect a company’s projected financial performance. Such models represent the financial situation by taking into account risks and future assumptions, which are critical for making significant decisions in the future, such as raising capital or valuing a business, and interpreting their impact.read more in many business models.

How to Open DAY Function in Excel?

Let us look below at some of the examples of the DAY function. These examples will help you explore the use of the DAY function in Excel.

  • First, we must enter the desired DAY formula in Excel in the required cell to attain a return value on the argument. We can manually open the DAY formula in the Excel dialog box in the spreadsheet and enter the logical values to attain a return value. You may consider the screenshot below to see the DAY formula in Excel under the Date Time Function menu. We must click on the DAY function Excel. As a result, the dialog box shall open, where we can enter the arguments to attain a return value, i.e., the day of the given specific date in this case.

Based on the above Excel spreadsheet, let us consider three examples and see the DAY formula return based on the function’s syntax.

Consider the screenshots of the above examples for a clear understanding.

Example #1

Example #2

Example #3

Example #4

Example #5

Applications

We can use the Microsoft DAY function for various purposes and applications within the spreadsheet. Some of the common applications of the DAY function in spreadsheets are given below:

  • To get a series of dates by yearTo add years to dateTo get a series of dates by monthTo get a day from the dateTo add days to a specific dateTo get the first day of the month

Common Problem

Sometimes, we can face a problem that the result of the DAY function is not an integer value between 1 and 31, but it looks like a date. This problem can arise when the cell or column is formatted as a”Date” instead of “General.” We have to format the cell or column as “General.”

Errors

If we get any error from the DAY function, then it can be any one of the following:

  • #NUM! – This error occurs in the DAY function when the supplied argument is a numeric value, but it is not recognized as a valid date.#VALUE! – This error occurs in the DAY function when the supplied argument is a text value and cannot be considered a valid date.

DAY Excel Function Video

This article has been a guide to the DAY Excel function. Here, we discuss the DAY formula in Excel and how to use it and examples, and a downloadable template. You may also look at these useful functions in Excel: –

  • WEEKDAY Excel FunctionWEEKDAY Excel FunctionThe WEEKDAY function in excel returns the day corresponding to a specified date. The date is supplied as an argument to this function. read moreTODAY Function in ExcelTODAY Function In ExcelToday function is a date and time function that is used to find out the current system date and time in excel. This function does not take any arguments and auto-updates anytime the worksheet is reopened. This function just reflects the current system date, not the time.read moreNOW In ExcelNOW In ExcelIn an excel worksheet, the NOW function is used to display the current system date and time. The syntax for using this function is quite simple =NOW ().read moreTIME in ExcelTIME In ExcelTime is a time worksheet function in Excel that is used to calculate time based on the inputs provided by the user. The arguments can take the following formats: hours, minutes, and seconds.read moreRecover Document in ExcelRecover Document In ExcelWhen an Excel document crashes unexpectedly while being worked on, certain amazing Excel workbook recovery techniques such as ‘Recover Unsaved Workbooks‘ and ‘Autosave‘ options come to the rescue of users.read more