This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
This is my formula:
=IF($F13="","", If($E13="Annual", Workday(Edate($F13,12)-1,1,Control!$A$12:$A$68),If($E13="Every Two Years", Workday(Edate($F13,24)-1,1,Control!$A$12:$A$68),If($E13="Every Three Years", Workday(Edate($F13,36)-1,1,Control!$A$12:$A$68),If($E13="Every Four Years", Workday(Edate($F13,48)-1,1,Control!$A$12:$A$68),If($E13="Every Five Years", Workday(Edate($F13,60)-1,1,Control!$A$12:$A$68),""))))))
I would like to modify this formula so if a due date falls on a Saturday or Sunday, the due date will roll back to Friday.
Thank you for the help.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
This formula in cell F6 will return the date of the Friday in the previous week if the date in cell D6 is a Sat/Sun
=D6-CHOOSE(WEEKDAY(D6,2),0,0,0,0,0,1,2)
Hope this helps.
I'd create a two-column range with the descriptions in the first column and the number of months in the second column:
Let's say it is Control!C12:D16.
=IF($F13="", "", LET(n, XLOOKUP($E13, Control!$C$12:$C$16, Control!$D$12:$D$16, ""), IF(n="", "", WORKDAY(EDATE($F13, n)+1, -1, Control!$A$12:$A$68))))