Due dates conundrum

[John.F]

I have a spreadsheet with a date field in column D,
If the date value in column D is equal to TODAY(), I need to display "Due Today" in Column F and leave column G blank or display "0"
If the date value in column D is before TODAY(). I need to display "Overdue" in Column F and VAL(number of days overdue) in column G
If the date value in column D is after TODAY(), I need to display "Due In" in column F and VAL(number of days until due date) in Column G.

I can do the number of days overdue, but I get #name errors for a value of TODAY() or future date.

 

[Jon von der Heyden]

Did you try my suggestion?

Formula in F2:
=LOOKUP(G2,{-9.99E+307,0,1},{"Due In","Due Today","Overdue"})

Formula in G2:
=TODAY()-D2

Format G2 as:
0;0;""

My 'spaces' comment was aimed at ganeshpoojary05. His formula was being truncated because of the inclusion of a greater than symbol. If you post formula with greater than and less than symbols one must make sure it has a space either side otherwise the forum will think it's HTML and it will be truncated.