Using the Work Day Formula to Calculate Due Date

Hi All,

I am trying to generate a formula that will calculate a due date (MM/DD/YYYY) based on working days of the month. My problem is that our team uses WD1, WD2, WD3, etc, to denote a due date, not dates in a date format. For example, WD1 in November would be 11/1/2024 and WD2 would be 11/4/2024. Does anyone have ideas on how I can achieve this? It would save our team a lot of time if these dates were automated each month. Thank you!!

Find more posts tagged with

Formulas

Accepted answers

All comments

SSFeatures

Hi @Mad4Accounting,

This formula will work for you:

=WORKDAY(DATE(2024, 11, 1), VALUE(SUBSTITUTE(WD@row, "WD", "")) - 1)

WORKDAY lets us get the date of a workday.
DATE(2024, 11, 1) tells the function to start calculating the workdays from November 1st.
SUBSTITUTE removes the "WD" from "WD1" so that we're left with "1".
VALUE converts "1" into the number 1.
We need to subtract 1 from VALUE so that the first workday is considered November 1st rather than November 4th.

Hope this helps!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.