Dynamic Scheduling with the TODAY Formula

The TODAY function returns the serial number of the current date. It is a 'volatile' function, meaning it updates every time your spreadsheet is opened or recalculated. It is essential for tracking deadlines, calculating employee tenure, or monitoring late payments.

How it Works?

Because the function has no arguments, the parentheses are left empty. You can perform arithmetic on this function as Excel treats dates as integers (e.g., TODAY()+30).

Example

To calculate how many days until a deadline in cell C2: =C2-TODAY()

Interactive Excel Demo