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