# Date Range = NetworkDays

Hello,

I am currently using the formula =NETWORKDAY(TODAY(), [Requested Due Date]@row) , my goal is to capture the days "today" and the requested due date. When the requested due date, is the same as today it is stating 1 instead of 0. How do I fix this? It seems to be counting today, as an active day.

• ✭✭✭✭✭✭

I hope you're well and safe!

At a glance, there seems to be a typo in Mark's formula. (square bracket after the first requested due date was pointing the wrong way)

Try this.

=IF( dateonly(today())=[requested due date]@row, 0, NETWORKDAY(TODAY(), [Requested Due Date]@row))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

Hi,

Try:

=IF( dateonly(today())=[requested due date[@row, 0, NETWORKDAY(TODAY(), [Requested Due Date]@row))

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• It is coming back with an error unparsable

• ✭✭✭✭✭✭

I hope you're well and safe!

At a glance, there seems to be a typo in Mark's formula. (square bracket after the first requested due date was pointing the wrong way)

Try this.

=IF( dateonly(today())=[requested due date]@row, 0, NETWORKDAY(TODAY(), [Requested Due Date]@row))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

Thank you@andree @Andrée Starå !

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Easy to miss.

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Hey Y'all,

Thank you for the help! The "0" is now showing. However, when trying to capture the late days it is counting the day of, and today's date. (Excluding weekends). Example - Due on 7/07, with today being 7/21 it is showing as 11 days late. Shouldn't this show as 10 days late?

Thank you

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!