See firsthand how to enter the date and time dynamically using the TODAY and NOW functions so that your spreadsheets stay current.
- [Instructor] There are two dynamic functions…related to dates and times you need to know about.…And we're on this worksheet called Dynamic Today Now,…Chapter Two, and those names you see them right there…are today and now.…In their current displays they're simply entered as text.…But in any given cell and sometimes you'll use this…by itself as I'm about to do here,…if you type =today and these can be used in formulas too,…type a single left parenthesis.…As with all functions…you don't need to capitalize it as you type it…but as soon as you type equal today left parenthesis…press Enter,…you will see today's date.…
It is May 8th at the time of this recording.…Now compare that with actual typing the date…or pressing control semicolon,…you might have learned that shortcut in a previous movie,…these look identical.…But if we save this file and open it tomorrow,…the top entry here,…the one that has the today function in it…will read May 9th 2017.…And as you look in the formula bar you see the function.…I'll double click here we can see it a bit larger,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.