calculation to exclude weekends

[Need2Know]

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

 

[Bob Phillips]

=A2-105 where A2 is the deadline date.

BTW, I make that 20th June.

 

[Need2Know]

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.

 

[Need2Know]

Thank you Bob,

how do you kow that it has skipped the weekends out of the 105 days?

 

[N Harkawat]

=WORKDAY(DATE(2005,10,3),-15*7)
I get 9th May 2005 as 105 days before deadline of 3rd October

 

[davideggy]

There is a function called WEEKDAY, if there is only 1 parameter, suc
as WEEKDAY(A2), it will return a number coresponding to a day of th
week (i believe 1 is sunday and 7 is saturday). I never played aroun
with the other parameters, but I think they alter the starting of th
numbering (ie make wednesday 1

 

[Bob Phillips]

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.