Jul 21 2020 06:53 AM
Jul 21 2020 06:59 AM
In C1:
=A1+IF(B1="quarterly",90,IF(B1="yearly",365,0))
In this example, the formula will return the same date as A1 if B1 is neither "quarterly" nor "yearly".
You can change the number 0 near the end of the formula if you want something else - for example 30 for an increase of a month, or 7 for an increase of a week.
Jul 21 2020 07:11 AM