add 4 days to date/time
 

Hi

Have had help with this, but still short of goal

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

Need to add 4 days

Examples

fri 3/3 07:00:00 result should be 9/3
fri 3/3 16:51:00 result should be 10/3
sat 4/3 any time result should be 10/3
sun 5/3 any time result should be 10/3
Mon 6/3 00:51:00 result should be 10/3

Any help, direction would be appriciated

regards

--
bnt

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

add 4 days to date/time
 

Sorry Brian, I thought I had responded to this

=WORKDAY(A1,IF(OR(WEEKDAY(A1,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:5d0a48f44499b@uwe...
Hi

Have had help with this, but still short of goal

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

Need to add 4 days

Examples

fri 3/3 07:00:00 result should be 9/3
fri 3/3 16:51:00 result should be 10/3
sat 4/3 any time result should be 10/3
sun 5/3 any time result should be 10/3
Mon 6/3 00:51:00 result should be 10/3

Any help, direction would be appriciated

regards

--
bnt

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

add 4 days to date/time
 

thanks bob, this is exactly what i required....VBG

regards



Bob Phillips wrote:
Sorry Brian, I thought I had responded to this

=WORKDAY(A1,IF(OR(WEEKDAY(A1,2)5,B1TIME(16,0,0) ),5,4))

Hi

[quoted text clipped - 18 lines]

regards

--
bnt

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