add 4 days to date/time

  • Thread starter Thread starter brian thompson3001 via OfficeKB.com
  • Start date Start date
B

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
 
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)
 
Back
Top