calculation to exclude weekends

=A2-105 where A2 is the deadline date.

BTW, I make that 20th June.

--
HTH

Bob Phillips

"Need2Know" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

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



"Need2Know" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?

Thank you Bob,

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
>

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



"Need2Know" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

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



"Need2Know" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>