DAY Excel Formula

Author Zaheer    Category Formulas     Tags ,

The Excel Date and Time Functions are pre-installed functions which aids in dates and times. The functions are grouped in a manner wherein the user can immediately find what function to use in a given situation. However, some of these functions are not pre-installed in the earlier versions of Excel. One of the Excel Date and Time Functions is DAY function which returns the date characterized by an integer such as the values from 1-31. The syntax of the function includes:

 =DAY (serial_number)

wherein the argument Serial_number refers to date if day that the user is trying to look. The date must be inputted with the use of DATE function and can also be a result of Excel functions and formulas.

Also, the values of the argument Serial_number can be from a date which was returned by an Excel formula or function or can also be from a source cell.

Remember that Excel dates are stored as numbers in sequential series for it to be employed in computations. In addition, the all returned values on years, months, and day would  Gregorian values no matter what format is employed  in the given value of date.

As an example, open a blank spreadsheet or worksheet and input the following data in cell A1 which is 15-Apr-2008 and input the formula in cell A2 as=DAY(A2) and the result will be 15. This means that the day on the given date value is 15.

If you want to view the formula from the result just hit the Ctrl+` (grave accent) on the keys. You could also do that by selecting Formulas tab, on it select Formula Auditing groups, and from the options select the Dhow Formulas.

If the result of the function is a date and not an integer, this is because the newly selected cell or column was formatted as date. To remedy this, highlight first the cells which were wrongfully formatted. After doing, right click the mouse, select the Format Cells form the options, and select the Number tab. On the Category select the option General and hit OK.

Post comment