Pre-dating a form

Copper Contributor

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.

2 Replies
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.

@loriC1958 

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