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 Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories