How to I push a date calculated to the next workday (Mon - Fri)? I have a date column that is calculated from a set date and applying an offset in another column. If the date returned form this (set date + offset) is a Sat or Sun, how can I move it to the next monday or the workday closest? If it is Sat, convert it to Friday, if Sun then bump it to Mon? Thanks.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Change calculated date to next workday (M-F)
0
Answers
0
Try this:
=IF(WEEKDAY(A4)=7,A4-WEEKDAY(A4-6),IF(WEEKDAY(A4)=1,A4+WEEKDAY(A4),""))I haven't fully tested it yet, but give it a go. Assumes date is in cell A4.