calculation to exclude weekends

=A2-105 where A2 is the deadline date.

BTW, I make that 20th June.

--
HTH

Bob Phillips

"Need2Know" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
>> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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
>> >
>

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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> > news:1121272575.927848.290470@g44g2000cwa.googlegroups.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
> > >
>

=A2-105 where A2 is the deadline date.

BTW, I make that 20th June.

--
HTH

Bob Phillips

"Need2Know" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
>> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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
>> >
>

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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> > news:1121272575.927848.290470@g44g2000cwa.googlegroups.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 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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
>> news:1121272575.927848.290470@g44g2000cwa.googlegroups.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
>> >
>

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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
news:1121360027.391512.60720@g43g2000cwa.googlegroups.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" <courtenay.kusitor@tm-ltd.co.uk> wrote in message
> > news:1121272575.927848.290470@g44g2000cwa.googlegroups.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
> > >
>