SharePoint Formula: [Created]+60 days = Extension Date (but need it to be a weekday)

Question

I need help with a formula that will add [Extension], a choice field of 30, 45, or 60, to [Created], and return a date [Extension Weekday].

BUT, that future date must be a weekday.

Example: [Created] + [Extension] = [Extension Weekday], but if the result is a Saturday or Sunday, calculate it as the next Monday.

Thanks!

Answer 1

You can use following formula:

=A2+B2+((WEEKDAY(A2+B2,2)=6)*2)+((WEEKDAY(A2+B2,2)=7)*1)

First weekday = 1 = Monday, last = 7 = Sunday. Change WEEKDAY function second parameter if needed.