Hi

The cell where the date appears probably says =TODAY()
That is a volatile function, which will re-calculate on each opening of
the sheet, and therefore will alter.

Instead of having the formula in the cell, press CTRL ; (hold down the
control button and press semicolon) and this will insert today's date
into a cell as a fixed value.

Regards

Roger Govier



Stop date changing to todays in Excel wrote:

When I open a previously created invoice in Excel, it automatically changes
the date of the invoice to todays date. I dont want that, I want to see when
I billed the guy, I want to stop this function, how do i do that?
email me at

thanks!