Today Function in Excel | Advance Excel Course

The TODAY function in Excel is a worksheet function that returns the current date 

Syntax 

=TODAY()

Arguments 

This function does not take any arguments.

Here are a few examples of using the TODAY function:

1. =TODAY() - returns the current date in the current cell.

2. =TODAY()+7 - adds 7 days to the current date and returns the result.

3. =IF(TODAY()>A1,"Expired","Not expired") - checks if the current date is after the date in cell A1 and returns "Expired" if it is, or "Not expired" if it is not.

1. =TODAY() - return the current date in the selected cell 

2. =TODAY()+7 - adds 7 days to the current date and returns the result.

3. =IF(TODAY()>A1,"Expired","Not expired") - 

checks if the current date is after the date in cell A1 and returns "Expired" if it is, or "Not expired" if it is not.