Because from your example, 15 weeks is 105 days. The weekend days are
irrelevant. Assuming that your project ends on a workday, 15 weeks before
must also be a workday.

--
HTH

Bob Phillips

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