maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Hello Excel Masters
in cell G25 I have the date 22-JAN-2024 which was populated using the below formula
=IF(COUNTIF(Helper!A:A,LEFT(TEXTAFTER(L25,"ETA: "),8))=1,LEFT(TEXTAFTER(L25,"ETA: "),8),IF(COUNTIF(Helper!B:B,LEFT(TEXTAFTER(L25,"ETA: "),11))=1,LEFT(TEXTAFTER(L25,"ETA: "),11),"Date Format Error"))
The below formula returns False if the date in cell G25 is in the future and False if it is in the past
=IF(DATEVALUE(TEXT(TODAY(),"dd-MMM-yyyy"))>DATEVALUE(G25),"T","F")
I want to set up conditional formatting to highlight all cells in column G that are in the past so I need help tweeking the above formula.
Note: Due to the way I am extracting the date in the first formula using > today() does not work
in cell G25 I have the date 22-JAN-2024 which was populated using the below formula
=IF(COUNTIF(Helper!A:A,LEFT(TEXTAFTER(L25,"ETA: "),8))=1,LEFT(TEXTAFTER(L25,"ETA: "),8),IF(COUNTIF(Helper!B:B,LEFT(TEXTAFTER(L25,"ETA: "),11))=1,LEFT(TEXTAFTER(L25,"ETA: "),11),"Date Format Error"))
The below formula returns False if the date in cell G25 is in the future and False if it is in the past
=IF(DATEVALUE(TEXT(TODAY(),"dd-MMM-yyyy"))>DATEVALUE(G25),"T","F")
I want to set up conditional formatting to highlight all cells in column G that are in the past so I need help tweeking the above formula.
Note: Due to the way I am extracting the date in the first formula using > today() does not work