# Networkdays between a date and today

Options

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

• ✭✭✭✭✭✭
Options

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])

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Options

thank you so much! It worked!

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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])

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Options

thank you so much! It worked!

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Options

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

• ✭✭✭✭✭✭
Options

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 (" ").

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!