Make Dated Progress Bar Exclude Weekends

Copper Contributor

Hey Friends,

 

I could use help making this progress bar exclude weekends. I tried several ways to insert the NETWORKDAYS formula fit into this one, but had no luck.

 

Formula:

=MIN((DATEDIF([start date cell],TODAY(),"d")+1)/(DATEDIF([start date cell],[end date cell],"d")+1),100%)

 

Any input is greatly appreciated!

1 Reply

@excelzero 

Does this do what you want?

 

=MIN(NETWORKDAYS([start date cell],TODAY())/NETWORKDAYS([start date cell],[end date cell]),100%)