Skip to content

Three More Date Functions

In this article, you will learn about three date functions that I have still yet to cover in the Spreadsheet Life blog.

The date functions covered in this article are:

  • DATE
  • WEEKDAY
  • WEEKNUM

These functions are all available in both Microsoft Excel and Google Sheets.

If you are excited to learn more about these fantastic functions, then dive right in!

The DATE Function

The DATE function is simple but can also be very useful.

The DATE function accepts three arguments and returns the date based on those arguments.

The arguments for the DATE function are:

  • The Year
  • The Month (1-12)
  • The Day (1-31)

Take a look at the example below.

The DATE function takes the year value of 2023, the month value of 1 (representing January), and the day value of 31 (representing the 31st day of the month).

The function then calculates and returns the date value.

As you can see, the DATE function is not complex or difficult to grasp, but it is certainly a good function to know.

The WEEKNUM Function

The WEEKNUM function calculates the week number of a specified date.

For example, the first week of the calendar year is number 1. The second week is number 2. And so on through December 31st.

The WEEKNUM function accepts two arguments.

  • The Date (Required)
  • The Type (Optional)

The first argument is simply the date you want the function to calculate the week number for.

The second argument is a number and specifies which weekday marks the beginning of a week. By default, this function treats Sunday as the beginning of the week.

Here is the WEEKNUM function in action.

The WEEKNUM function takes the date as the first argument and has no second argument specified. Therefore, the function considers Sunday as the beginning of the week by default.

As you can see on the calendar, January 31st falls under the 5th week of the year, so the WEEKNUM function returns a value of 5.

The WEEKDAY Function

The WEEKDAY function calculates the weekday of a specified date.

It returns a number from 1 to 7. By default, the number one represents Sunday, and the seven represents Saturday.

The WEEKDAY function accepts two arguments.

  • The Date (Required)
  • The Type (Optional)

The first argument is simply the date you want the function to calculate the weekday number for.

The second argument is a number and specifies which number represents which weekday. You can use this argument to change the default behavior of 1 representing Sunday.

Here is the WEEKDAY function in action.

The WEEKDAY function takes the date as the first argument and has no second argument specified. Therefore, the function considers number one as a representation of Sunday.

As you can see on the calendar, January 31st is a Tuesday which is the 3rd day of the week. Therefore, the WEEKDAY function returns a value of 3.

And those are your three new date functions for this article. I hope you enjoyed adding these functions to your mental warehouse!

This Post Has One Comment

  1. These are all so helpful! I can’t wait to start using WEEKNUM. I didn’t even know that was a thing Excel could do!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top