Conditional formatting using dates in different cells

Solved/Closed
rbarletta
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013
- Mar 5, 2013 at 03:58 PM
rbarletta
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013
- Mar 6, 2013 at 12:38 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 5, 2013 at 11:23 PM
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
rbarletta
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013

Mar 6, 2013 at 12:38 AM
Thank you for a quick response.

Worked exactly how I needed it to!!!

Such a big help!!! Thank you!
0