Conditional formatting using dates in different cells [Solved/Closed]

Report
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013
-
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013
-
Hello,

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!!!

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
First how would I do it :-)

A1: is date started (required)
b1: is date finished (optional)

C1: days worked
=IF(A1="","",IF(B1<>"",b1-a1,today()-a1))


Now on to your question
=and(a1<>"",b1="",today()-a1>30)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013

Thank you for a quick response.

Worked exactly how I needed it to!!!

Such a big help!!! Thank you!