formulas for date&time in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1457374%22%20slang%3D%22en-US%22%3Eformulas%20for%20date%26amp%3Btime%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457374%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20help%20with%20a%20formula%20for%20date%26amp%3Btime%20in%20excel%20cell%3F%20Goal%3D%20enter%20date%20and%20current%20time%20stamp%20will%20populate%20and%20not%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1457374%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-1457929%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%20for%20date%26amp%3Btime%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696883%22%20target%3D%22_blank%22%3E%40vclsmith%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20insert%20Date%20and%20Time%20in%20a%20single%20cell%2C%20press%20CTRL%2B%3B%20(semi%20colon).%20Then%2C%20press%20space%20bar%20on%20your%20keyboard%20and%20execute%26nbsp%3BCTRL%2BSHIFT%2B%3B%20(semi%20colon)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1591923942089.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198286i12984B6A57F30E9D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1591923942089.png%22%20alt%3D%22Abiola1_0-1591923942089.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorAbiola1_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorAbiola1_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3DNOW()%20function%20will%20return%20Date%20and%20Time%20(which%20is%20volatile)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459357%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%20for%20date%26amp%3Btime%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%26nbsp%3B%20We%20were%20hoping%20for%20a%20better%20way%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1838001%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%20for%20date%26amp%3Btime%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1838001%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3EQuick%20Q%3CBR%20%2F%3EIs%20this%20formula%20dynamic%20or%20static%3CBR%20%2F%3EStatic%20meaning%20it%20will%20update%20when%20you%20open%20the%20tab%20or%20file%20bext%20time.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20tell%20us%20the%20formula%20for%20dynamic%20if%20the%20is%20formula%20used%20for%20static.%20Kind%20regards%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Can someone help with a formula for date&time in excel cell? Goal= enter date and current time stamp will populate and not change.

 

3 Replies
Highlighted

@vclsmith 

 

To insert Date and Time in a single cell, press CTRL+; (semi colon). Then, press space bar on your keyboard and execute CTRL+SHIFT+; (semi colon)

 

Abiola1_0-1591923942089.png

 

 

 
 

=NOW() function will return Date and Time (which is volatile)

 

Highlighted

@Abiola1

 

Thank you very much.  We were hoping for a better way 

Highlighted
Hi
Quick Q
Is this formula dynamic or static
Static meaning it will update when you open the tab or file bext time.

Can you tell us the formula for dynamic if the is formula used for static. Kind regards