How to insert the exact date/time in a Google Sheet as well as an Excel Spreadsheet

If you are in need of inserting the exact date and time in a Google Sheet or Excel Spreadsheet try the following.

• Google Sheets
• in an open cell type in 
• =now()
• this will enter in the exact date and time
• to adjust select Format > Number > adjust to date / time, etc.
• to enter in just the day 
• =today()
• In Excel
• in an open cell type in 
• =(now)
• right click in cell and select format cell
• format the cell to what you would like

• to enter in just the date 
• =today()

Embedded below is a 1 minute and 16 second YouTube tutorial.

Take care,

Brad