maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Cell J1 contains the following text: Remark: 02-JAN-2024 (CL):
Cell D1 contains this formula: =MID(" "&LEFT(TEXTAFTER(J1,"Remark"),18),FIND("-"," "&LEFT(TEXTAFTER(J1,"Remark"),18),1)-2,11)
Cell D1 Formula Results: 02-JAN-2024
Cell G1 contains this formula: =D1<=TODAY()
Cell G1 Formula Results: False
I am completely baffled as to why Cell G1 returns False rather than True?
If in cell D2 I put the formula: =D1+1 it returns 1/3/2024 so this tells me D1 is being treated like a real date but I am stumped
Cell D1 contains this formula: =MID(" "&LEFT(TEXTAFTER(J1,"Remark"),18),FIND("-"," "&LEFT(TEXTAFTER(J1,"Remark"),18),1)-2,11)
Cell D1 Formula Results: 02-JAN-2024
Cell G1 contains this formula: =D1<=TODAY()
Cell G1 Formula Results: False
I am completely baffled as to why Cell G1 returns False rather than True?
If in cell D2 I put the formula: =D1+1 it returns 1/3/2024 so this tells me D1 is being treated like a real date but I am stumped