## Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

# Tag: DAY function

## DAY function: Description, Usage, Syntax, Examples and Explanation

What is DAY function in Excel? DAY function is one of Date and Time functions in Microsoft Excel that returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Syntax of DAY function DAY(serial_number) The DAY function syntax has the following arguments: Serial_number: The date of the day you are…

## How to calculate nth day of week in month in Excel

To get the nth day if week in a month (i.e. the first Tuesday, third Tuesday, forth Thursday, etc.) you can use a formula based on the DAY and WEEKDAY functions. Formula =date-DAY(date)+1+n*7-WEEKDAY(date-DAY(date)+8-dow) Note:  Day of week is abbreviated “dow” in the generic form of the formula. This is a number between 1 (Sunday) and 7 (Saturday) which can be changed…

## Get week number from date in Excel

If you need to get the week number from the day from a date, you can use the WEEKNUM function. The date must be in a form that Excel recognizes as a valid date. Note: The WEEKNUM function takes two arguments, a date, and, optionally, an argument called return_type, which controls the scheme used to calculate the week number. Formula =WEEKNUM(date)…

## How to generate series of dates increment by 1 year from a single start date in Excel

If need to generate a dynamic series of dates with a formula that increase by one year from a single start date, you can do so with a formula that uses the DAY, MONTH, YEAR, and DATE functions. Formula =DATE(YEAR(date)+1,MONTH(date),DAY(date)) Explanation In the example, B6 is the hard-coded start date and the formula in B7 is: =DATE(YEAR(B6)+1,MONTH(B6),DAY(B6)) To solve this…

## Display Days in month in Excel

This tutorial shows how to Display Days in month in Excel using example below. To get the number of days in a given month from a date, you can use a formula based on the EOMONTH and DAY functions. Formula =DAY(EOMONTH(date,0)) Explanation In the example shown, the formula in cell B5 is: =DAY(EOMONTH(B5,0)) How this formula works The DAY function…

## Get day from date in Excel

This tutorial show how to Get day from date in Excel using the example below. If you need to extract the day from a date, you can use the DAY function. Formula =DAY(date) Explanation of how this formula works In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date.…

## Add years to date in Excel

If you need to add years to date in Excel then this tutorials is for you. See the example below . To add a given number of years to a date, you can use a formula based on the DATE function, with help from the YEAR, MONTH, and DAY functions. Formula =DATE(YEAR(date)+years,MONTH(date),DAY(date)) Note: if you need to add an “even” multiple…