Tuesday, September 25, 2018

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