calculation to exclude weekends

  • Thread starter Thread starter Need2Know
  • Start date Start date
N

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
 
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.
 
=WORKDAY(DATE(2005,10,3),-15*7)
I get 9th May 2005 as 105 days before deadline of 3rd October
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup help. lookup result based on data in 2 columns 3
Calculate End Date (excluding weekends and holidays) 6
Exclude Weekends 4
Ignoring Blank cells in 'IF' formula 2
How do I compare two times to see if one is "late" or "on time"? 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Ignore Weekends on Task Due Calculations 1
Little bit annoyed 5

Back
Top