in A3

If you hit F2 to edit then press return it produces the correct date
Not sure why???