So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But
=IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction.
And i try this code, but i cant figure out how make it run.
=IF([Promised Date]4 > TODAY(0), "Expired date", "-", IF(NOT(ISBLANK([Completion Date]4)), "Completed", "-"))
Does any one has any suggestions?
Hope everyone has a great day