Join Dennis Taylor for an in-depth discussion in this video Use the dynamic TODAY and NOW functions for real-time up-to-date calculations, part of Excel Tips Weekly.
When you work with time sensitive data…there will be situations where you need…to rely upon functions that give us…the current date and/or the current time.…In this particular work sheet,…we want to calculate the age based on a birth date,…but we want this entry always to be correct.…The same thing with the service years.…How long has this person been here?…If it's today that I'm talking about,…I might get a certain number, but a year from now…that number's going to be larger or three years from now.…I want to use this file and always make sure…that this data here is up to date,…as well as the data that we're going to put in here.…
A quick reminder, the two functions that we're talking about…are called today and now.…Like all functions, they're followed by parentheses,…but if you're simply typing the function by itself…and you probably wouldn't need to do this very often,…but if you're typing =today, type the left parenthesis…and that's it, press enter.…At the time of this recording it's November 29th of 2016.…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.