add days without adding weekend

[brian thompson3001 via OfficeKB.com]

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

 

[Bob Phillips]

=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]

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

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

Hi

[quoted text clipped - 11 lines]

brian

 

[Bob Phillips]

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)

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

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

Hi

[quoted text clipped - 11 lines]

brian

 

[brian thompson3001 via OfficeKB.com]

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.

Hi Bob
keep getting #name?

[quoted text clipped - 11 lines]

 

[brian thompson3001 via OfficeKB.com]

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?

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]

 

[Bob Phillips]

That's exactly what it does for me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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?

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

 

[brian thompson3001 via 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?

That's exactly what it does for me.

Hi

[quoted text clipped - 20 lines]

 

[Bob Phillips]

=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)

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?

That's exactly what it does for me.

Hi

[quoted text clipped - 20 lines]

brian

 

[brian thompson3001 via 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

=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]

 

[Bob Phillips]

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)

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

=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

 

[brian thompson3001 via 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

Brian,

I think it would help if you give examples of all the possibilities and

Hi bob

[quoted text clipped - 11 lines]