TODAY

Definition: The TODAY function in Excel is used to return the current date.

Syntax: ==TODAY().

Situation: This formula is appropriate in situations where you need to get the current date.

Example: If you want to calculate the number of days until an event that is happening on January 1, 2022, you would use the formula =DATEDIF(TODAY(), “1/1/2022”, “d”). This would return a value that indicates the number of days until January 1, 2022.