RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 810
- Office Version
- 365
- Platform
- Windows
Hopefully a quick one. I'm referencing a date (31/12/2018) as a variable "date1"
I'm then going onto another sheet and saying if the value in B is >= date1 and <= date2 then do this.
When I set it to 31/12/2018, even though this cell is less than the value in B (which is 07/01/2019), it doesn't work. However, if I change date1 to be 01/01/2019 it does work.
Somehow 01/01/2019 is valid as being less than 07/01/2019, but 31/12/2018 isn't working.
Any ideas?
Thanks.
I'm then going onto another sheet and saying if the value in B is >= date1 and <= date2 then do this.
When I set it to 31/12/2018, even though this cell is less than the value in B (which is 07/01/2019), it doesn't work. However, if I change date1 to be 01/01/2019 it does work.
Somehow 01/01/2019 is valid as being less than 07/01/2019, but 31/12/2018 isn't working.
Any ideas?
Thanks.