I am trying to modify the formula for forecast. Currently, the formula counts the total days of the month. I am trying to modify the formula to count only business days. It will be easy to delete the weekends, but I need the weekend numbers for the total at the end of the month. What formula will work for the forecast? this is the formular currently Chart!$C$17*COUNT($A$2:$A2)
Forecast formular help
- Thread starter Osaseme
- Start date
Somendra Misra
Excel Ninja
Hi Osaseme,
Welcome to Chandoo.org forum.
Suppose your Start date say 01-June-2014 is in cell E13 and you want to calculate no. of working days (Excluding Saturdays & Sundays) you can use below formula.
=NETWORKDAYS(E13,EDATE(E13,1)-1)
Just advise if you want something else.
Regards,
Welcome to Chandoo.org forum.
Suppose your Start date say 01-June-2014 is in cell E13 and you want to calculate no. of working days (Excluding Saturdays & Sundays) you can use below formula.
=NETWORKDAYS(E13,EDATE(E13,1)-1)
Just advise if you want something else.
Regards,