Compare date in cell against dates in range of cells
Closed
Grimsby21
Posts
1
Registration date
Thursday January 31, 2013
Status
Member
Last seen
January 31, 2013
-
Jan 31, 2013 at 03:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 31, 2013 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 31, 2013 at 11:02 AM
Related:
- Compare date in cell against dates in range of cells
- Beyond compare - Download - File management
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 31, 2013 at 11:02 AM
Jan 31, 2013 at 11:02 AM
Hi Grimsby,
I used column A for completion date and columns B, C and D for action dates.
Conditional format, formula is:
=OR(AND(N(B2)>0,B2>=A2),AND(N(C2)>0,C2>=A2),AND(N(D2)>0,D2>=A2))
Text will now be recognised as the value 0 and thus be negated.
Best regards,
Trowa
I used column A for completion date and columns B, C and D for action dates.
Conditional format, formula is:
=OR(AND(N(B2)>0,B2>=A2),AND(N(C2)>0,C2>=A2),AND(N(D2)>0,D2>=A2))
Text will now be recognised as the value 0 and thus be negated.
Best regards,
Trowa