I Have Dates In Column A,B,C And E I Calculate No Of Days Between A Or B Or C And E , For Calculates Dates Some Conditions To Be Followed By
Date should follow the check start with C column then A Column At Last B
Calculation of days should start with C:C column if C column Date not found or Greater than Close Date then ( in case if found less than Close date c3-e3) No of Days
Calculation formula turn to A:A column if A column Date not found or Greater than Close Date then ( in case if found less than Close date a3-e3) No of days
Calculation formula turn to B:B Column if B column Date not found or greater than close date then Result ( in case if found less than Close date b3-e3) No of days
NO DATES FOUND
ALL DATES GREATER THAN CLOSE
find the attachment
Bookmarks