Auto Populating Dates but Skipping the Weekend

[jamian0607]

I need to make a schedule for testing where I check the samples every 3 days but if that date hits on a weekend I want it to role over to the monday if it hits on a Sunday and Friday if it hits on a Saturday. In other words wait an extra day if it hits on a Sunday and check the sample a day early if it would normally be on a Saturday.

I have been playing around with the WORKDAY command and some of the other date functions but I can't figure this one out.

Any help would be appreciated!

 

[barry houdini]

Would you want the next day after that to revert to the pattern or just be three days after the previous? For example if your start date is a Thursday then StartDate+3 will give you Sunday so the formula needs to return Monday. What date do you want next, just Monday+3 or StartDate+6?

 

[jamian0607]

I need it to go Monday +3

 

[barry houdini]

OK, if first date is in A2 just put this formula in the next cell and copy down or across as required

=A2+3+CHOOSE(WEEKDAY(A2+3),1,0,0,0,0,0,-1)

....but as soon as you hit a Monday or Thursday you'll get in a repeating pattern of Mon/Thurs/Mon/Thurs etc.......