HI EVERYONE,
i have a task sheet in which there are some tasks in sheet named delegation. column c is task details and d is frequency of tasks (monthly, yearly, half yearly, fort nightly, daily, etc.) and column f is the specific time when the work has to be done. column g6 to iv46is work area where the formula has applied so that it can indicate that particular day when the work has to be done. my requirement is that i have applied formula but some of terms are not working properly.

for example take c11 which has to be done fortnightly(d11). and f11 is 8/22/2019. so it is showing up 9/5/2019(k11), but not showing up all the next dates. 9/19/2019 and so on....

for d13 (quarterly) date is 9/2/2019(f13). this is showing due date in cu13 but same not calculating next further months.

and there is no formula for half yearly in the exist formula. so please add that also.

i have two formulas which i am applying in the sheet. in the other one quarterly term is working. but fortnightly and hal yearly is not working. (the formula is in g16 to iv38. correct any one with all of the terms which are written in column d in delegation sheet. here is the link of file.https://docs.google.com/spreadsheets...gid=1669533612