1-Conditional formatting and expired dates / 2-Count difference between 2 dates

[suzie_blue]

Hello!
I have 2 questions about a spreadsheet I'm working on:

1- I would like the dates in column B (attached) to be highlighted in red when the date is expired. I used conditional formatting with a formula - however it doesn't work AT ALL! I cannot see what is the issue. Can someone help please? Also sometimes september appears like "sep" and sometimes like "sept", do you know if there is an issue and workaround for this conditional formatting of expired dates?

2-I looked all over the internet but could not find any formula for my second question:
In column J - I would like to have the difference (in days) between 2 dates: [D]-
But: if [D] is blank - I would like to substract [G]- (row 69)
But again: if [G] is blank - I would like to substract -

Does anybody knows if we can use a formula for that?

Thank you very much in advance for your help!
suzie_blue

 

[vletm]

suzie_blue​

case #1
If You're working with dates ... then please use dates.
Some of Your A- & B-column values are dates ... check green cells.

 

[ETAF]

you are using C2 not b2
and selecting B:B
$B1<today()

as mentioned dates are TEXT

i do not follow the 2nd question, seems a a few things missing
looks like you need a nested IF ()

but nothing will work if the dates are text

 

[suzie_blue]

Hello again,

Thank you very much ! Some of these dates were not in the date format - the conditional formatting works now!

Regarding my second question - it seems that my text got truncated. Sorry for that. Please find below my question.

2-I looked all over the internet but could not find any formula for my second question:
In column J - I would like to have the difference (in days) between 2 dates: [D] - [A]
But: If [D] is blank - I would like to substract [G] - [A]
But again: if [G] is blank - I would like to substract [ I ] - [A]

Does anybody knows if we can use a formula for that?

Thank you very much in advance for your help!
suzie_blue

 

[vletm]

suzie_blue​

case #1
No matter of dates format - but dates have to be dates = numbers.

case #2
What about if I-column is empty?
Here one sample...

 

[suzie_blue]

Thank you very much for your help @vletm !
I tried to do it myself and it seems that it is not working for columns 69 (the results is a big big number) and 70 (it shows unresolved but it is resolved on 8th of September.
Do you know by any chance what I wrote wrong in the formula? The columns changed a little bit (A, E, H and G for the dates and K for the result).
Thanks again!
suzie_blue

 

[vletm]

suzie_blue​

Where comes *H2 to Your formula?
=IFERROR(IF(E2>0,E2,IF(H2>0,H2,J2)*H2)-A2,"unresolved")
Test something like my original
=IFERROR(IF(E2>0,E2,IF(H2>0,H2,J2))-A2,"unresolved")