0

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?

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.