Home / Beginner / How to use Day, Month and Year Functions

How to use Day, Month and Year Functions

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.

About Excel Help Desk

Check Also

Split Function

The Split function is a VBA function that is used for breaking strings into an array. The separation of string is identified by indicating a character or set of characters which are called delimiters. This function comes in handy, for example, when you have a list of whole names of people in a column of your worksheet and you want to split them in order to get the first and last names of each person.

3 comments

  1. Love the template for quotes, but cannot change $ to £ Also cannot get in logo or any photo

  2. Please advise me re: year to date totals on a monthly payroll spreadsheet. I need to accummulate totals from one month to the next using the same spreadsheet.

    • Susan,

      Thanks for your question can you send through a sample of the spreadsheet that you are trying to total from month to month for. We can then update with a formula to acheive that
      support@excelhelpdesk.com

      Regards
      ExcelHelpDesk Support Team