G
Guest
How to insert date in excel cell
P
Peo Sjoblom
Type the date in a cell and press enter or do ctrl + ;
G
Guest
=now() - date and time
or ctrl and ; - just the date
or ctrl and ; - just the date
G
Guest
You could also use the formula:
=Today()
Try this!!!
=Today()
Try this!!!
G
Guest
When I do this it updates the time/date in all cells (using it to track task
start and stop times). How do I limit the update to just the cell I have
selected?
start and stop times). How do I limit the update to just the cell I have
selected?
R
Roger Govier
Hi Bart
Typing Ctrl +; (that's Control + Semicolon) inserts the current date as a
fixed value in a cell
Control + Shift + Semicolon (i.e Ctrl+Colon Ctrl+
inserts the current
time
Typing Ctrl +; (that's Control + Semicolon) inserts the current date as a
fixed value in a cell
Control + Shift + Semicolon (i.e Ctrl+Colon Ctrl+
inserts the currenttime