Forum Discussion
Make Dated Progress Bar Exclude Weekends
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!
Does this do what you want?
=MIN(NETWORKDAYS([start date cell],TODAY())/NETWORKDAYS([start date cell],[end date cell]),100%)
