Nested if
Hi
With Due Date in A1 and Submitted in B2
=IF(AND(B2="",TODAY()-A2<=0),"Waiting",
IF(AND(B2="",TODAY()-A20),"Late",
IF(AND(B2<"",A2-B2<0),"Late","on time")))
Change "Waiting to "" if you just want to show an empty cell where it is
neither Late nor On time
--
Regards
Roger Govier
"mwavra" wrote in message
...
I have been trying to figure this out for quite a while and can't get
anything to work. Here's what I have.
A list of due date, date submitted. I want to show in another column,
when
something is late or on time. If not submitted yet, and due date is
today or
beyond, the late/on time indicator can be blank. If blank and due date
has
passed, show late. If submitted by or before due date, it's on time.
Hope someone can help me construct the correct formula.
Thanks.
|