Google Sheets: How to Find Last Business Day of Month


You can use the following formula to find the last business day of the month for a given date in Google Sheets:

=WORKDAY(EOMONTH(A2, 0)+1, -1)

This particular formula will return the last business day of the month for the date in cell A2.

The following example shows how to use this formula in practice.

Example: How to Find Last Business Day of Month in Google Sheets

Suppose we have the following column of dates in Google Sheets:

Suppose that we would like to find the last business day of the month associated with each date in column A.

To do so, we will type the following formula into cell B2 to find the last business day of the month for the date in cell A2:

=WORKDAY(EOMONTH(A2, 0)+1, -1)

We can then click and drag this formula down to each remaining cell in column B:

Google Sheets last business day of month

Column B shows the last business day of the month that the date in column A belongs to.

For example, the first date in the Date column of 1/25/2023 belongs to the month and year of January 2023.

If we refer to a calendar, we can see that the last business day of January 2023 is on Tuesday the 31st:

Thus, our formula correctly returns 1/31/2023.

How This Formula Works

Recall the formula that we used to find the last business day of the month for the date in cell A2:

=WORKDAY(EOMONTH(A2, 0)+1, -1)

Here is how this formula works:

First, the EOMONTH function finds the last day of the month for the date in cell A2.

Next, we add 1 to get the first day of the next month.

Lastly, we use the WORKDAY function with an argument of -1 to go back one business day, which will be the last business day of the month for the date in cell A2.

We repeat this process for every other date in column A.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Use IF Function Based on Month
Google Sheets: How to Show Date as Month Name
Google Sheets: How to Filter Dates by Month

Leave a Reply

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