The formula below is returning a 0 (zero) on date formatted column which results in 1/0/00. This is impacting other conditional formatting I have in place. How can I update it to where if it doesn't find anything to return, to simply return a blank vs 0...?
=IFERROR(INDEX(Milestones!$AA$5:$AB$1254,IF(CM$4<>"",AGGREGATE(15,6,(ROW($A$5:$A$1254)-ROW($A$4))/(Milestones!$H$5:$H$1254=$B7)/(Milestones!$Z$5:$Z$1254=CM$4)/(Milestones!$M$5:$M$1254<>"Agile Workflow"),1),AGGREGATE(15,6,(ROW($A$5:$A$1254)-ROW($A$4))/(Milestones!$H$5:$H$1254=$B7)/(Milestones!$Z$5:$Z$1254=CL$4)/(Milestones!$M$5:$M$1254<>"Agile Workflow"),1)),IF(CM$6="target",1,2)),"")
Bookmarks