I need help with a problem that is driving me insane.
I have column A, B, and C
A is date started
B is date finished
C is days it took to complete
Using "=TODAY()-$A4" I have computed the days worked.
I need to use C.F. so that if there is a finished date in the column B cell then the column C cell is blank ... I am only trying to mark cells in column C that are over 30 days without a closed date in the corresponding B cell ...
Any and all help are truly appreciated!!!
Conditional formatting using dates in different cells