Today Function in Excel

Posted on:  01/20/2021
Today Function in Excel

The TODAY function returns the current date. The TODAY function is updated continuously when a worksheet is opened. For example: if you use the TODAY function in cell B1, it will show today's date. Assume that today is 12/21/2021. Tomorrow, it will have the correct date of 12/22/2021.

This video will use the TODAY function with an accounting exercise and an HR exercise. I'll also demonstrate Averageif, Countif, and other functions I use with the Today function.

YouTube Video on the TODAY function

Arguments for TODAY function

The TODAY function takes no arguments.=TODAY() Notice there is nothing between the parentheses. There are other functions with no arguments. Another popular date and time function is the NOW function. =NOW() which returns the date and time is continuously updated.

Functions with one argument

Some functions use one argument, or where one input is needed. Examples of functions using one argument include Sum, Max, Min, Median, and Average.

Examples of functions with one argument

  • =Sum(B2:B12)
  • =Average(B2:B12)
  • =Median(B2:B12)
  • =Max(B2:B12)

Functions with multiple arguments

Some functions have multiple arguments where multiple input is needed. You get a new argument when you add a comma in the function. Excel functions that require multiple arguments.

Examples of functions with multiple arguments

  • =COUNTIF(B2:B15,"GA") Finds people that live in GA in states are listed in column B.
  • =LARGE(C2:C15,2) Finds the 2nd largest number
  • =LARGE(C2:C15,3) Finds the 3rd largest number
  • =SMALL(C2:C15,2) Finds the 2nd smallest number
Related articles

Functions used in video

Average Function

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Averageif Function

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

Countif

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

DateDif

Calculates the number of days, months, or years between two dates.

Chris Menard

Chris is a Microsoft Office Master. He trains corporate clients in Microsoft Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and a senior lecturer at the University of Georgia Terry College of Business. Menard's YouTube channel has over 600 technology videos. Chris works full-time as a Training Specialist for a global law firm. His office is in midtown, Atlanta.

Categories