Description: I created a conditional date format in my date column, and it doesn't work. Steps to Reproduce: 1.Click on conditional, then date 2.Choose date is for yesterday, then choose a style 3.Click on add, the date is, the, choose today, and choose a style once again. 4.Hit shrink, and then highlight A2:A50 which contain date from 6/1/24 - 7/15/24, and then hit enter. Actual Results: The date in A2 is 6/1/24, so the condition for yesterday should have kicked in for today, but didn't. I won't know until tomorrow if the other style will kick in. Expected Results: The date in A2 for 6/1/24 with the condition for yesterday should kick in for today, but didn't. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows 10 OS is 64bit: yes Copied from the information from menu Help - About LibreOffice. Version: 7.6.6.3 (X86_64) / LibreOffice Community Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
In the web page for the bug report, please use the "Add an attachment" link to add a simplified minimal sample file that shows the problem. Please be aware that the file will be publicly available.