Change calculated date to next workday (M-F)

0

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.

Answer
Discuss

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login