TODAY Function

The TODAY Function in Excel returns the current date in a selected cell. This returned date updates as a spreadsheet is opened or modified. You can press F9 to recalculate the spreadsheet. Lets look at the Syntax for the TODAY Function.

Syntax:

 =TODAY ()

The TODAY Function has no arguments. You can add and subtract from the returned date.

TODAY Function Usage Example:

Review the example below.

You can format the returned date for using the Format Cells feature in Excel.

Need the current Date and Time, you can use the NOW Function.

SUMIFS Function

July 7, 2019 No Comments

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Named Ranges in Excel – Setup, Rules, and Uses

August 22, 2019 No Comments

Learn how to use Named Ranges in Excel.

YEARFRAC Function

December 13, 2019 No Comments

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date,