today() without changing after daychange

hi there again,
i would like to use some function like today()in my excel worksheet, but i don't want it to be change after a day change.
is this possible?
Thank you
great forum you have here
regards

You specify a static date using the DATE function.

Dom

Here is simple code to attach to a macro key or you can change the sub to a function and it will then become a User Defined Function.

Please Login or Register  to view this content.

Alan

Something like

Please Login or Register  to view this content.

In any cell test it by typing the formula =StaticDate(). Format the cells to show date eg dd/mm/yyyy

You can also just press Ctrl+; to get today's date in the active cell.

Dom