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

Options

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.

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    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! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!