Forum Discussion
excelzero
Jul 03, 2024Copper Contributor
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([st...
HansVogelaar
Jul 03, 2024MVP
Does this do what you want?
=MIN(NETWORKDAYS([start date cell],TODAY())/NETWORKDAYS([start date cell],[end date cell]),100%)