Column formulas
I need to subtract two days from an end date@ row and exclude weekends and holidays. Can I use this formula and incorporate the -2 days somehow? NETWORKDAYS(start_date, end_date, [holidays])
Thanks,
Best Answer
-
You need a column with the Holidays listed (Date type column) and update the formula to match that new column. You input the holidays and it will take those into consideration when subtracting 2 days from end date.
=WORKDAY([End Date]@row, -2, Holidays:Holidays)
Answers
-
I would use =WORKDAY([End Date]@row, -2). You'll need to add a Holiday column but can use that to exclude those as well.
-
Thanks so how would the Holiday formula work? =WORKDAY([Holiday]@row ???)
-
You need a column with the Holidays listed (Date type column) and update the formula to match that new column. You input the holidays and it will take those into consideration when subtracting 2 days from end date.
=WORKDAY([End Date]@row, -2, Holidays:Holidays)
-
I appreciate the prompt assistance!!
-
Realized one more issue when using =WORKDAY([End Date]@row, -2) as my column formula.
Let me provide context. This is a calendar creation using column formulas in the grid view and workflows to manage notifications to specific people 2 days prior to the event. Issue is... if a form entry event submission is for tomorrow the -2 days from the end date does not send the notification. How can I adjust the column formula or workflow to send the notification when <= 2 days from the event? Ty
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!