Excel DAY Function

Excel TEXT Function

Excel MONTH Function

It returns the day of a month, i.e. integer from 1 to 31.

Syntax:

DAY(serial_number)

Arguments:

1. serial_number: This value represents the day of the month you want to find. E.g: 5th day of June

Example 1

Example 2

The DAY(TODAY()) function returns the day of today’s date, as shown below:

Excel Date Functions with Formula Examples

There are many functions in Microsoft Excel that may be used to work with dates and timings in Excel. Each function completes a straightforward task, but by combining numerous functions into a single formula, you may handle trickier and more complicated problems. The purpose of discussing DATE functions in Excel is to help different people perform more complex and challenging tasks by combining several functions within one formula.

The DATE function is used to calculate dates in Excel. To work with these formulas you first need to insert the dates in Excel. Excel provides different functions to work with dates & times such as TODAY, NOW, WEEKDAY, EOMONTH, etc. which we will discuss here with examples.

Excel DATE function List

DATE Function

Get the Current date and Time

TODAY- It returns today’s date.
NOW– It returns the current date and time.

Converts Dates to / From text

DATEVALUE– Helps to Convert date in the text format to date format
TEXT– It helps to convert a date to a text value.

Retrieve dates in Excel

DAY– It returns the day of the month
MONTH– It is used to return the month of a specified date
YEAR- It is used to return the year of a specified date
EOMONTH– It returns the last day of the month.
WEEKDAY– It is used to return the day of the week.
WEEKNUM– It is used ti return the week number of a date.

Calculate date difference

DATEDIF– It is used to return the difference between two dates
EDATE- It is used to return a date N months before or after the start date.
YEARFRAC- It is used to calculate the fraction of the year between 2 dates.

Calculates Workdays

WORKDAY- It returns a date N working days in the future or in the past.
WORKDAY.INTL– It returns a date N weekdays from the start date with custom weekends