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(B1TIME(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(B1TIME(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(B1TIME(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,
ToolsAddins.

--
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(B1TIME(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(B1TIME(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,
ToolsAddins.

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,
ToolsAddins.
[quoted text clipped - 4 lines]

brian

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