Hi Bob
Thank you for your reply...how do you know that it has automatically
skipped the weekends out of the 105 days?

Thank you.


Bob Phillips wrote:
=A2-105 where A2 is the deadline date.

BTW, I make that 20th June.

--
HTH

Bob Phillips

"Need2Know" wrote in message
oups.com...
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