|
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 |
=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 |
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 |
Thank you Bob,
how do you kow that it has skipped the weekends out of the 105 days? |
=WORKDAY(DATE(2005,10,3),-15*7)
I get 9th May 2005 as 105 days before deadline of 3rd October "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 |
There is a function called WEEKDAY, if there is only 1 parameter, such as WEEKDAY(A2), it will return a number coresponding to a day of the week (i believe 1 is sunday and 7 is saturday). I never played around with the other parameters, but I think they alter the starting of the numbering (ie make wednesday 1) -- davideggy ------------------------------------------------------------------------ davideggy's Profile: http://www.excelforum.com/member.php...o&userid=25239 View this thread: http://www.excelforum.com/showthread...hreadid=386882 |
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 |
| All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com