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.



=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


Does this do what you want?


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