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)
I have the following formula: =IFERROR(IF(OR(ISNUMBER(SEARCH("Expedite",D4)),ISNUMBER(SEARCH("Urgent",D4))),H4,WORKDAY(MAX(IF(ISNUMBER(I4),I4,H4),K4,L4,M4),IF(G4="Once",0,-3),Control!$A$1:$A$13)),"")I need to modify this to reflect the following:If G4 = "Annual", the renewal date needs to be 1 year from the date in cells H4:M4IF G4="Every 2 Years", the renewal date needs to be 2 years from the date in cells H4:M4 If G4="Every 3 Years", the renewal date needs to be 3 years from the date in cells H4:M4
If G4="Once", there is no renewal date
My holiday list: Control!$A$1:$A$13
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.
Dear CarolF_1
Sorry if I sounded offensive to you I was only trying to drop my idea and I don't think I used any word or tried berating you in any way
Adekunle,
I'm aware that this is a user community. I've been on this platform and have asked similar questions and have gotten helpful answers from others. If you couldn't offer any assistance, don't reply to this question or any question similar to this one and leave these types of questions to those who are willing to assist not berate.
Dear CarolF_1
To modify your formula based on the described conditions, you can use the following adjusted formula: =IFERROR( IF( OR( ISNUMBER(SEARCH("Expedite", D4)), ISNUMBER(SEARCH("Urgent", D4)) ), H4, IF( G4 = "Annual", WORKDAY(H4, 365, Control!$A$1:$A$13), IF( G4 = "Every 2 Years", WORKDAY(H4, 365 * 2, Control!$A$1:$A$13), IF( G4 = "Every 3 Years", WORKDAY(H4, 365 * 3, Control!$A$1:$A$13), "" ) ) ) ), "" )
This adjusted formula checks the value in G4 and calculates the renewal date accordingly: 1 year for "Annual," 2 years for "Every 2 Years," 3 years for "Every 3 Years," and an empty string for "Once." The holiday list is also considered in the WORKDAY function.
Best regard Adekunle
Hi CarolF_1
thank you for coming to the forum, my name is Adekunle.its worth noting that this is a user community and we are all users here. while we strive to assist and share insights we are not microsoft.