Pre-dating a form

%3CLINGO-SUB%20id%3D%22lingo-sub-1508715%22%20slang%3D%22en-US%22%3EPre-dating%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508715%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20pre-date%20a%20form%20-%20instead%20of%20writing%20in%20the%20date%2C%20the%20forms%20will%20already%20have%20the%20date%20printed%20on%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20remember%20reading%20instructions%20on%20how%20to%20do%20it.%20But%20naturally%2C%20now%20that%20I%20have%20a%20use%20for%20this%20I%20can't%20find%20the%20instructions%20anywhere.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1508715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509060%22%20slang%3D%22en-US%22%3ERe%3A%20Pre-dating%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509060%22%20slang%3D%22en-US%22%3Enot%20sure%20what%20you%20need%20here.%20the%20function%20NOW()%20will%20give%20you%20the%20present%20date%2Ftime%20and%20you%20can%20format%20that%20cell%20in%20the%20date%20format%20you%20want.%3C%2FLINGO-BODY%3E
Occasional Visitor

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/