Last working day of the current month

I need some help with the following formula:

=WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0)

The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025).

Can someone tell me what is wrong with the formula that it's not giving me a date?

Find more posts tagged with

Formulas

Accepted answers

DKazatsky2

Hi @Mariann Carmen,

The reason you are getting an error is because this section - MONTH(TODAY()) + 1 - is equating to a month of 13, which does not exist. You need to account for the month of December separately. The following formula should get you to where you expect to be today.

=IF(MONTH(TODAY() ) < 12, WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0), WORKDAY(DATE(YEAR(TODAY()), 12, 31), 0))

Now, having said that, this formula is returning the last day of the month, regardless if it's a weekend or weekday, is that what you wanted?

Hope this helps,

Dave

All comments

DKazatsky2

Hi @Mariann Carmen,

=IF(MONTH(TODAY() ) < 12, WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0), WORKDAY(DATE(YEAR(TODAY()), 12, 31), 0))

Now, having said that, this formula is returning the last day of the month, regardless if it's a weekend or weekday, is that what you wanted?

Hope this helps,

Dave

Mariann Carmen

This worked perfectly. Thank you! ❤️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.