Current formula:
=IF(M4=AA4,"No action required",IF(AND(DAY(P4)=31,MONTH(P4)=12),"No action release date tbc",IF(AND(DAY(L4)=31,MONTH(L4)=12),"Action amend RequestDat to 14/12/2023 release tbc",IF(AND(AA4<TODAY(),L4<TODAY()),"No action both dates in the past",IF(AA4=L4,"No action dates in line",IF(AND(L4<TODAY(),AA4>TODAY()),"Action amend RequestDat, original past and newcalculation future ",IF(AND(L4>TODAY(),AA4<TODAY()),"Action amend RequestDat, original after newcalculation","Action amend RequestDat as both in future")))))))
I need to add somewhere but not sure where to add the the below snippet:
=IF(M4="Allocation Block","No action required",
