The NOW function in Excel is a worksheet function that returns the current date and time in the current cell.
Syntax
=NOW()
Arguments
This function does not take any arguments.
Here are a few examples of using the NOW function:
1. =NOW() - returns the current date and time in the current cell.2. =NOW()+7 - adds 7 days to the current date and time and returns the result.3. =NOW()-TIME(12,0,0) - subtracts 12 hours from the current time and returns the result.