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