Date Range = NetworkDays

Elaine Mullis

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.

Screen Shot 2021-07-16 at 8.41.46 PM.png

Andrée Starå

Hi @Elaine Mullis

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!

Mark Cronk

Hi,

Try:

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

Work?

Mark

Elaine Mullis

It is coming back with an error unparsable

Andrée Starå

Hi @Elaine Mullis

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!

Mark Cronk

Thank you@andree @Andrée Starå !

Andrée Starå

@Mark Cronk

Easy to miss.

You're more than welcome!

Elaine Mullis

@Andrée Starå & @Mark Cronk

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