How to use Day, Month and Year Functions

3
213

In many cases when working with Excel the we use dates to calculate formulas or display a report. The ability to use the built-in Excel functions that relate to dates and to extend them is a fundamental skill in Excel. This post is the first in a series that will describe the basic use of key functions in Excel for beginners.

Today() Function

This function will display in the selected cell the current date in the default format for your version of Excel.

Step 1

Open a new workbook, click on cell B3, enter the following into the cell
=TODAY()

Step 2

Press Enter and the current date will be displayed within the cell

There is another function that can also be used in place of Today() and that is the Now() function. The Now() function not only returns the current date but also the current time.

Day() Function

This function will display the day of the month as a number from 1 to 31 based on a given date.

Step 1

In the open workbook, click on cell B4, enter the following into the cell
=DAY(B3)

Step 2

Press Enter and the current day will be displayed within the cell

Month() Function

This function will display the month of the year as a number from 1 (January) to 12 December based on a given date.

Step 1

In the open workbook, click on cell B5, enter the following into the cell
=MONTH(B3)

Step 2

Press Enter and the current month will be displayed within the cell

Year() Function

This function will display the year as a number in the range 1900 – 9999 based on a given date.

Step 1

In the open workbook, click on cell B6, enter the following into the cell
=YEAR(B3)

Step 2

Press Enter and the current year will be displayed within the cell

Once you master these Date based functions in Excel they can be used in other formulas and functions. These types functions are very useful in Pivot Tables and Charts to enable the calculation of monthly and yearly totals very quickly.

If you have a question on this post for the Excel Help Desk team or have something you would like to share on this topic then please leave a comment.