the formula in the ‘value for new rows’ prints the data as a text value (thus without a formula behind it), so you can edit the date. Give it a try and you will notice how handy that is, also in other configurations.
that said, glad you solved it with a bit of creativity.
cheers, christiaan