Networkdays between a date and today

Wina Hathaway

=NETWORKDAYS([date to vendor]1, [today], [holidays])

Help! I need to calculate the number of days since a date and today excluding holidays.

Thank you!

Jeff Reisman

The holidays part of the formula refers to a date column in your sheet (or a date column range in another sheet) where you list the dates for the holidays you want excluded from your count.

To include the current date as part of your range to count, use the TODAY(0) function.

So create a "Holidays" column in your sheet and populate it with the holiday dates, then try this:

=NETWORKDAYS([date to vendor]1, TODAY(0), [Holidays]:[Holidays])

If you want to use this formula on many rows in your sheet, use an @row reference in place of the row number. This will work on any row to count the net work days from the "date to vendor" filed in that row to today.

=NETWORKDAYS([date to vendor]@row, TODAY(0), [Holidays]:[Holidays])

Wina Hathaway

thank you so much! It worked!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/317194#Comment_317194

Glad I could help. If you could mark my answer as the accepted answer that would be great, thanks!

Jeff Reisman

The holidays part of the formula refers to a date column in your sheet (or a date column range in another sheet) where you list the dates for the holidays you want excluded from your count.

To include the current date as part of your range to count, use the TODAY(0) function.

So create a "Holidays" column in your sheet and populate it with the holiday dates, then try this:

=NETWORKDAYS([date to vendor]1, TODAY(0), [Holidays]:[Holidays])

If you want to use this formula on many rows in your sheet, use an @row reference in place of the row number. This will work on any row to count the net work days from the "date to vendor" filed in that row to today.

=NETWORKDAYS([date to vendor]@row, TODAY(0), [Holidays]:[Holidays])

Wina Hathaway

thank you so much! It worked!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/317194#Comment_317194

Glad I could help. If you could mark my answer as the accepted answer that would be great, thanks!

jack.deragon30

Hey Jeff, I seem to be targeting the same goal. The formula I have entered is:

=NETWORKDAYS([Date Scheduled]@row, TODAY(0), [Holidays]:[Holidays])

I am getting the UNPARSEABLE response.

Any help would be greatly appreciated.

Thanks

Jeff Reisman

https://community.smartsheet.com/discussion/comment/342524#Comment_342524

First thing to check is that your Date Scheduled column and Holiday column are both date-type columns and populated with real date values, and that the column names aren't misspelled in your formula.

UNPARSEABLE is kind of a catch-all error message in Smartsheet:

Cause

The formula has a problem which prevents it from being parsed and interpreted. This can happen for many reasons, such as misspelling, incomplete operators, using the wrong case for a column name, or using single quotes instead of double quotes.

Resolution

Ensure that all column names are spelled correctly in cell references, operators are being used correctly, and any text strings in the formula are surrounded by double quotes (" ").