• Hi all!!

    I'm trying to compare to dates, if the completed (G9) is greater than the due date (F9) by using the following:


    In some cases I do not have a value in Column G and the output is defacto TRUE, how can I get it to display nothing if there is nothing in G?

    I was then thinking of adding a conditional formatting on Column G to say that if Cell G = FALSE the cell would be filled RED - is ther a better way of doing this?

    Many thanks,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!