Question

To enter the current date we use_______ function​

Answer 1

Explanation:

The NOW function is categorized under Excel DATE/TIME functions. The function returns the current date and time.

In financial analysis, the NOW function can be useful in preparing various KPI reports. We can use it to display the current date and time, as it will continually update each time the worksheet is refreshed. For example, every time a value is entered or changed, NOW will update the date and time. If we want, we can use F9 to force the worksheet to recalculate and update the value.

 

Formula

=NOW()