Adding a "Completion Date" that only consits of week days

Hi,

Likely a simple question / resolution so i'll appologise in advance! I'm working on a fairly basic spreadsheet to aid the IT department track progress with New Starter requests.

In the sheet, we have a user start date. i'd like a column that coppies that date, but minuses 2 working days from the date, e.g if i do =[Start Date]@row - 2 for a date that lands on a monday, the completion date becomes a saturday.

The issue with this, is i have set automated emails to trigger on the completion date, as the buisness is only working Mon-Fri this is troublesome.

Find more posts tagged with

Accepted answers

All comments

Nick Korna

Hi @Joechaptaylor,

You can use WORKDAY for this:

=WORKDAY([Start Date]@row, -2)

Will take 2 days off your start date, ignoring weekends. If you have a list of holidays, this can also be added.

Hope this helps, but if you've any problems/questions then just post! 🙂

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.