Pre-dating a form

Question

I need to pre-date a form - instead of writing in the date, the forms will already have the date printed on them.

I remember reading instructions on how to do it. But naturally, now that I have a use for this I can't find the instructions anywhere.

Thanks.

mtarler · Answer

not sure what you need here. the function NOW() will give you the present date/time and you can format that cell in the date format you want.

sergeibaklan · Answer

loriC1958&nbsp;
If you mean timestamp which is automatically added based on some condition, that is like&nbsp;https://chandoo.org/wp/timestamps-excel-formula-help/

Forum Discussion

Pre-dating a form

2 Replies