# How to Get the Last Monday of the Month in Google Sheets

If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when is the last Monday of the month (or any other last weekday day of the month).

In this tutorial, I will show you how to use formulas in Google Sheets to do this.

## Formula to Calculate the Last Monday of the Month

Suppose you want to know what would be the date of the last Monday in the month of June 2018.

Below is the formula that will give it to you:

=EOMONTH(DATE(2018,5,1),0)-WEEKDAY(EOMONTH(DATE(2018,5,1),0),2)+1

### How does the formula work?

There are 3 Google Sheets functions that are used to calculate this:

• EOMONTH: This function finds the last date of a given month. It stands for ‘End Of Month’.
• WEEKDAY: This function tells us the weekday number of a given date. In this example, the last date of June 2018 was 30/6/2018 which was a Saturday. So Weekday function gave us 6 for Saturday (the numbering started from Monday. So Monday is 1, Tuesday is 2, and so on).
• DATE: This function gives us the date when we specify the year, month and day value.

Now let me try and break it down further:

EOMONTH(DATE(2018,5,1),0)

This part of the formula would give us the last date in June 2018. Note that I have used ‘0’ as the second argument (which gives us the last date of the month to which the date in the first argument belongs).

You can also use this function to get the last date of the previous/next month (instead of 0 use 1 for next month and -1 for the previous month).

WEEKDAY(EOMONTH(DATE(2018,5,1),0),2)

The above part of the formula tells us what weekday is the last day of the month. In this example, this will return 6, as the last day of the week is Saturday.

=EOMONTH(DATE(2018,5,1),0)-WEEKDAY(EOMONTH(DATE(2018,5,1),0),2)+1

Finally, this formula gives us the last Monday of the month.

You can also use this same technique to calculate any day of the month. For example, if you want to know the third Thursday in June 2018, you can use the below formula:

=EOMONTH(DATE(2018,6,1),-1)+1+IF(WEEKDAY(EOMONTH(DATE(2018,6,1),-1)+1,2)>4,4-WEEKDAY(EOMONTH(DATE(2018,6,1),-1)+1,2)+7,4-WEEKDAY(EOMONTH(DATE(2018,6,1),-1)+1,2))+7*2

This technique can also be used to calculate holidays in a year. For example, if you want to know the date of Labor Day, which is first Monday in September, then you can use this technique.

You May Also Like the Following Google Sheets Tutorials:

FREE EBOOK - GOOGLE SHEETS TIPS

10 Google Sheets Tips that will save you hours every week

### Leave Tracker Template in Google Sheets (Updated for 2019)

Looking for a leave tracker template in Google Sheets that can track leaves of your employees or students? You’re in the right place. In this post, I am sharing one of my best templates –

### Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

### Show / Hide Gridlines in Google Sheets (in less than 5 seconds)

Just like most of the spreadsheet tools, Google Sheets also have gridlines around the cells in it. These gridlines make it easy for you to clearly see the data and read it. But sometimes you

### How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google