A SHARP COOKIE
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home

Adventures In Technology

Using Dates in Excel

2/8/2018

0 Comments

 
I love Excel and use it daily.  Working with dates can frustrating if you don't know the keyboard shortcuts and functions/formulas.

=NOW() and =Today()  insert the current time/date and update whenever the sheet updates.  This is good if you have a report and you want to show the date when it was last updated.
=DAY(TODAY()) is the current day of the month.
=MONTH(TODAY()) is the current month.

If you want the dates to stay put, use CTRL and ; (semi-colon).  The time is CTRL + SHIFT + ;.





0 Comments



Leave a Reply.

    Author

    Teacher, Writer, Editor, Instructional Designer.

    Archives

    June 2021
    May 2021
    April 2021
    September 2020
    November 2019
    February 2018
    January 2018

    Categories

    All
    Access
    Accessibility
    Camtasia
    Canvas
    Design
    Excel
    Google Suite
    Microsoft Office
    Power Point
    Stream
    Technology Tips
    Word
    Zoom

    RSS Feed

Services

Tech Training
Content Writing
Editing
Formatting
Publishing

Company

A Sharp Cookie

Support

Contact
FAQ
Terms of Use
© COPYRIGHT 2015. ALL RIGHTS RESERVED.
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home