I am trying to create a simple formula for deadlines. After several hours I cannot figure out why it won't work. Any help would be greatly appreciated!
=IF(NOT(ISBLANK(G2)),IF(G2>TODAY(),“Due in “&G2-TODAY()&” days”,IF(G2=TODAY(),“Due today”,IF(G2<H2,“Late filed”,“Timely filed”))),IF(NOT(ISBLANK(F2)),IF(F2>TODAY(),“Due in “&F2-TODAY()&” days”,IF(F2=TODAY(), “Due today”,IF(F2<H2,“Late filed”,“Timely filed”))),IF(NOT(ISBLANK(E2)),IF(G2>TODAY(),“Due in “&G2-TODAY()&” days”,IF(E2=TODAY(),“Due today”,IF(E2<H2,“Late filed”,“Timely filed”))))))
chart with 5 columns: 1 deadline 2 extension 3 extension 4 date of filing 5 status
Aucun commentaire:
Enregistrer un commentaire