add days without adding weekend

Hi

Trying to add 4 days to date in cell A1, without counting weekend and if poss
bank holidays. in cell C1
example
cell a1 = date
cell b1 = time

If time after 1600 hrs needs to be classed as next day. Then i have to add 4
days to that new date
any help appriciated

thanks in advance

brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

=WORKDAY(A1,IF(B1>TIME(16,0,0),5,4))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5cc4cd0caec36@uwe...
> Hi
>
> Trying to add 4 days to date in cell A1, without counting weekend and if
poss
> bank holidays. in cell C1
> example
> cell a1 = date
> cell b1 = time
>
> If time after 1600 hrs needs to be classed as next day. Then i have to
add 4
> days to that new date
> any help appriciated
>
> thanks in advance
>
> brian
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

Hi Bob
keep getting #name?
=WORKDAY(A1,(IF(B1>TIME(16,0,0),5,4)))
is there any special format for date and time,
using
4-Feb 23:01:00

regards
Bob Phillips wrote:
>=WORKDAY(A1,IF(B1>TIME(16,0,0),5,4))
>
>> Hi
>>
>[quoted text clipped - 11 lines]
>>
>> brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

Sounds like you don't have the Analysis Toolpak add-on installed,
Tools>Addins.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5cd13365fa832@uwe...
> Hi Bob
> keep getting #name?
> =WORKDAY(A1,(IF(B1>TIME(16,0,0),5,4)))
> is there any special format for date and time,
> using
> 4-Feb 23:01:00
>
> regards
> Bob Phillips wrote:
> >=WORKDAY(A1,IF(B1>TIME(16,0,0),5,4))
> >
> >> Hi
> >>
> >[quoted text clipped - 11 lines]
> >>
> >> brian
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

your right !

have tried at work and it works

thanks again

Bob Phillips wrote:
>Sounds like you don't have the Analysis Toolpak add-on installed,
>Tools>Addins.
>
>> Hi Bob
>> keep getting #name?
>[quoted text clipped - 11 lines]
>> >>
>> >> brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

Hi

Celebrated too soon

Realised that I require any time after 1600 the next day. to be classed as
the following day, then + 4. If between fri 1600hrs and mon 0000, classed as
monday, then add 4
Example
fri 3/3 1623. therefore Mon + 4 = 10/3
fri 1500 = therefore Fri = 9/3

Any idea's?

brian thompson3001 wrote:
>your right !
>
>have tried at work and it works
>
>thanks again
>
>>Sounds like you don't have the Analysis Toolpak add-on installed,
>>Tools>Addins.
>[quoted text clipped - 4 lines]
>>> >>
>>> >> brian

--
Message posted via http://www.officekb.com

That's exactly what it does for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5cddcaec4d57f@uwe...
> Hi
>
> Celebrated too soon
>
> Realised that I require any time after 1600 the next day. to be classed
as
> the following day, then + 4. If between fri 1600hrs and mon 0000, classed
as
> monday, then add 4
> Example
> fri 3/3 1623. therefore Mon + 4 = 10/3
> fri 1500 = therefore Fri = 9/3
>
> Any idea's?
>
> brian thompson3001 wrote:
> >your right !
> >
> >have tried at work and it works
> >
> >thanks again
> >
> >>Sounds like you don't have the Analysis Toolpak add-on installed,
> >>Tools>Addins.
> >[quoted text clipped - 4 lines]
> >>> >>
> >>> >> brian
>
> --
> Message posted via http://www.officekb.com

That's exactly what it does for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5cddcaec4d57f@uwe...
> Hi
>
> Celebrated too soon
>
> Realised that I require any time after 1600 the next day. to be classed
as
> the following day, then + 4. If between fri 1600hrs and mon 0000, classed
as
> monday, then add 4
> Example
> fri 3/3 1623. therefore Mon + 4 = 10/3
> fri 1500 = therefore Fri = 9/3
>
> Any idea's?
>
> brian thompson3001 wrote:
> >your right !
> >
> >have tried at work and it works
> >
> >thanks again
> >
> >>Sounds like you don't have the Analysis Toolpak add-on installed,
> >>Tools>Addins.
> >[quoted text clipped - 4 lines]
> >>> >>
> >>> >> brian
>
> --
> Message posted via http://www.officekb.com

understand, but if date of 4/3/06 and time 02:01:01 , then it returns a date
of 09/03/06 and require 10/3/6

Is it possible to get my result?

Bob Phillips wrote:
>That's exactly what it does for me.
>
>> Hi
>>
>[quoted text clipped - 20 lines]
>> >>> >>
>> >>> >> brian

--
Message posted via http://www.officekb.com

=WORKDAY(A1,IF(OR(WEEKDAY(,2)>5,B1>TIME(16,0,0)),5,4))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5ce43931d82b7@uwe...
> understand, but if date of 4/3/06 and time 02:01:01 , then it returns a
date
> of 09/03/06 and require 10/3/6
>
> Is it possible to get my result?
>
> Bob Phillips wrote:
> >That's exactly what it does for me.
> >
> >> Hi
> >>
> >[quoted text clipped - 20 lines]
> >> >>> >>
> >> >>> >> brian
>
> --
> Message posted via http://www.officekb.com

Hi bob

nearly there !

The weekend's do seem to be givinng problems. Any weekend date and friday
after 1600, to reflect mondays date

regards
Bob Phillips wrote:
>=WORKDAY(A1,IF(OR(WEEKDAY(,2)>5,B1>TIME(16,0,0)),5,4))
>
>> understand, but if date of 4/3/06 and time 02:01:01 , then it returns a date
>> of 09/03/06 and require 10/3/6
>[quoted text clipped - 8 lines]
>> >> >>> >>
>> >> >>> >> brian

--
Message posted via http://www.officekb.com

Hi bob

nearly there !

The weekend's do seem to be givinng problems. Any weekend date and friday
after 1600, to reflect mondays date

regards
Bob Phillips wrote:
>=WORKDAY(A1,IF(OR(WEEKDAY(,2)>5,B1>TIME(16,0,0)),5,4))
>
>> understand, but if date of 4/3/06 and time 02:01:01 , then it returns a date
>> of 09/03/06 and require 10/3/6
>[quoted text clipped - 8 lines]
>> >> >>> >>
>> >> >>> >> brian

--
Message posted via http://www.officekb.com

Brian,

I think it would help if you give examples of all the possibilities and
expected results, let's get it finished <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5cf41483ca8b6@uwe...
> Hi bob
>
> nearly there !
>
> The weekend's do seem to be givinng problems. Any weekend date and friday
> after 1600, to reflect mondays date
>
> regards
> Bob Phillips wrote:
> >=WORKDAY(A1,IF(OR(WEEKDAY(,2)>5,B1>TIME(16,0,0)),5,4))
> >
> >> understand, but if date of 4/3/06 and time 02:01:01 , then it returns a
date
> >> of 09/03/06 and require 10/3/6
> >[quoted text clipped - 8 lines]
> >> >> >>> >>
> >> >> >>> >> brian
>
> --
> Message posted via http://www.officekb.com

Bob you are very patient !

vehicles are released for delivery, and the clock starts ticking. we have 5
days to deliver.

1) release date counts as day 1
2) anything after 1600 is classed as next day's release
3) anything after 1600 on friday, sat and sun is classed as monday release

Examples

fri 3/3 07:00:00 delivery date 9/3
fri 3/3 16:51:00 delivery date 10/3
sat 4/3 delivery date 10/3
sun 5/3 delivery date 10/3
Mon 6/3 00:51:00 delivery date 10/3

thanks

Bob Phillips wrote:
>Brian,
>
>I think it would help if you give examples of all the possibilities and
>expected results, let's get it finished <vbg>
>
>> Hi bob
>>
>[quoted text clipped - 11 lines]
>> >> >> >>> >>
>> >> >> >>> >> brian

--
Message posted via http://www.officekb.com