Use the dynamic TODAY and NOW functions for real-time up-to-date calculations

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.…