The NOW function is a volatile function that updates whenever the worksheet is recalculated. It is useful for displaying the current date and time on a report or calculating intervals based on the current moment.
=NOW()→10/25/2023 14:30Returns the current system date and time.
=NOW()+7→11/01/2023 14:30Returns the date and time exactly one week from now.
Select a cell
Click on the cell where you want to display the current date and time.
Enter the formula
Type =NOW() into the cell and press Enter.
NOW is a volatile function, meaning it recalculates every time any change is made to the worksheet.