From the course: Excel Formulas and Functions Quick Tips

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Perform date calculations with TODAY()

Perform date calculations with TODAY() - Microsoft Excel Tutorial

From the course: Excel Formulas and Functions Quick Tips

Start my 1-month free trial Buy for my team

Perform date calculations with TODAY()

“

- [Instructor] The TODAY function has no parameters and returns the current date. I'll put in an equal sign, write today and use my open and close parentheses. The date is based on the date of the computer that Excel is running on. This date will change and update every time this Excel file is opened. But you can use Today to perform calculations. Let's find out how many days this gift card has been active for. Cell A2 contains the date it was issued. We can subtract that from today's date. Excel will put an odd date in there by default. If I look in the ribbon I can see that it's formatting it as a date field. You can fix this by changing to the number data cell type. You can also decrease the decimal to get a count of days.

Contents