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

Joechaptaylor

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.

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