add 4 days to date/time

[brian thompson3001 via OfficeKB.com]

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

 

[Bob Phillips]

Sorry Brian, I thought I had responded to this

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[brian thompson3001 via OfficeKB.com]

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

regards

Sorry Brian, I thought I had responded to this

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

Hi

[quoted text clipped - 18 lines]

regards