View Single Post
  #1   Report Post  
Need2Know
 
Posts: n/a
Default calculation to exclude weekends

Hi all
I wonder if someone can help me with this.

I have to get my designs done 15 weeks (105 days) before the deadline.
For one of my projects my deadline is 3rd Oct
and I want to calculate in 1 cell what day i need to complete the
project - 15 weeks before the deadline but excluding the weekends, can
you help me find a formula for this?

My Deadline is 3rd Oct, i should be completing the project on 28th
June? how can i get excel to calculate the correct completion date?

Thank you for your help
Need2