find min dates calculates aging from AJ column with determined formula

[johnodys]

Dear excel experts

i need help on formula if taken dates greater than business date, move to min date of second option

i have small conditions formula to calculates dates aging from 3 dates column result minus with particular column
e.g if date not found in FIRST cell of AU, then take SECOND Date cell of AG then THIRD Date cell of AC. Taken cell minus with business end date.... Some times taken cell values may be higher than business end result should be - value


find the attachment help with your efforts...

[johnodys]

any experts help on this?????????

=IFERROR(IF(J2="ZSP1",IF(AU2="",IF(AG2="",IF(AC2="","No Date Found",IF(AJ2-MIN(AC2,AG2,AU2)>=30,">30 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=20,"21-30 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=16,"16-20 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=11,"11-15 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=6,"6-10 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=3,"3-5 Days",IF(AJ2-MIN(AC2,AG2,AU2)>=0,"0-2 Days"," ")))))))),IF(AJ2-AG2>=30,">30 Days",IF(AJ2-AG2>=20,"21-30 Days",IF(AJ2-AG2>=16,"16-20 Days",IF(AJ2-AG2>=11,"11-15 Days",IF(AJ2-AG2>=6,"6-10 Days",IF(AJ2-AG2>=3,"3-5 Days",IF(AJ2-AG2>=0,"0-2 Days"," ")))))))),IF(AJ2-AU2>=30,">30 Days",IF(AJ2-AU2>=20,"21-30 Days",IF(AJ2-AU2>=16,"16-20 Days",IF(AJ2-AU2>=11,"11-15 Days",IF(AJ2-AU2>=6,"6-10 Days",IF(AJ2-AU2>=3,"3-5 Days",IF(AJ2-AU2>=0,"0-2 Days"," "))))))))," ")," ")