Can't do basic date calculations

Originally Posted by JohnTopley

Excel will (should!) recognise 2/20/2023 as date with whatever format is used for the cell. See attached (UK format dates)

I just can't get it to recognize the 2/20/2023, the 2023-02-20 format works fine.