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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!