I often struggle with formulas that involve dates, and this one is no different. If the value in C7 = "Annually" and the date in D7 is less than 12/01/2023, I want to update the value of G7 to 12/01/2023. Otherwise, if the value in C7 = "Annually" and the date in D7 is greater than 12/01/2023, I want to update the value of G7 to 12/01/2024. I already have this formula in column G, so I'm hoping I don't need to next 11+ other IF statements to do this.
=IF(C2="Adhoc","Adhoc",IF(C2="Daily",D2+1,IF(C2="Weekly",D2+7,IF(C2="Monthly",EDATE(D2,1),IF(C2="Quarterly",EDATE(D2,3))))))
=IF(C2="Adhoc","Adhoc",IF(C2="Daily",D2+1,IF(C2="Weekly",D2+7,IF(C2="Monthly",EDATE(D2,1),IF(C2="Quarterly",EDATE(D2,3))))))