Calculating the days between two given dates and highlighting column colors

[vk7]

I wanted to find out days between two given dates (i.e G2). I have tried using the formula DATEDIF but for some reason it doesn't give me any results.

In addition, I would like to set colors to "Total Outstanding" Column (i.e C2:C5). If the Total Outstanding Amount is greater Credit Card Limit (i.e Column B) then the text should be in Red Color if not then in normal Black Color Text. Same condition applies to Total too. Any help would be appreciated. Attached the sample file with this message.

 

[pecoflyer]

=DATEDIF(E2,F2,"d") ( always check syntax before using a formula)
For your CF select col C and use $C2>$B2 as condition
Format as needed

Date in F4 is not a real date but text. Re enter manually
Watch out with manual alignment

 

[bosco_yip]

1] Date in F4 : 31-Nov-2018 is an error

2] In the month of Nov don't have 31 days, it should read as 30-Nov-2018

Regards
Bosco

 

[GraH - Guido]

Why not simply use LastDate-FirstDate (F2-E2), since dates are simply numbers in Excel?