Column formulas

Ron Erdeljac

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,

Nic Larsen

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)

Nic Larsen

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.

Ron Erdeljac

Thanks so how would the Holiday formula work? =WORKDAY([Holiday]@row ???)

Nic Larsen

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)

Ron Erdeljac

I appreciate the prompt assistance!!

Ron Erdeljac

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