Google-sheets – How to use conditional formatting to choose between columns for a datedif function

conditional formattinggoogle sheets

I am trying to find the difference between two dates using this function =DATEDIF(G2,K2,"D"). I always want to find the difference between column K and either G or H depending on which one has a date. If a cell doesn't have a date it will have - in it.

How can I write an if function or filter to achieve this?

Best Answer

You might try:

=datedif(max(G4:H4),K4,"D")

but may want to add some error trapping, in case K is less than G/H or they are both-.

I have absolutely no idea how or where Conditional formatting is involved in this.

Related Solutions

Google Sheets – How to Write a Logical Function to Check Multiple Columns and Rows

Logical operators such as OR return single values in array formulas, try instead:

=ARRAYFORMULA(SUM(IF(IF($C$4:$C$4000 <= H55; 1; 0)+IF($C$4:$C$4000 <> ""; 1; 0)+IF(($D$4:$D$4000 = "")+($D$4:$D$4000 > H55);1;0)+IF(($E$4:$E$4000 = "")+( $E$4:$E$4000 > H55);1;0)=4; 1; 0)))

Google-sheets – How to check if a cell is blank for Conditional formatting

With the range set to: B3:O1000

Try:

=AND(ISBLANK(B3),INT($A3)=INT(today()))

or even shorter:

=AND(ISBLANK(B3),$A3=today())

Best Answer

Related Solutions

Google Sheets – How to Write a Logical Function to Check Multiple Columns and Rows

Google-sheets – How to check if a cell is blank for Conditional formatting

Related Topic