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

add days without adding weekend
 

=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

add days without adding weekend
 

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

add days without adding weekend
 

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

add days without adding weekend
 

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

add days without adding weekend
 

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

add days without adding weekend
 

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

brian

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

add days without adding weekend
 

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

add days without adding weekend
 

=WORKDAY(A1,IF(OR(WEEKDAY(,2)5,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: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

add days without adding weekend
 

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

add days without adding weekend
 

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

add days without adding weekend
 

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