This video tutorial shows "How to use NOW function in Excel" using simple methods.

As we know, there are many "Date and Time" functions in Excel, and NOW function is one of the most commonly used Data & Time function, which is usually used to return the current date and time to a worksheet by reading the computer’s serial date. It returns the serial number of the current date and time and automatically changes the cell format from general to date and time format as per regional setting is set on your system.

NOW function takes no arguments but requires parentheses. It is a "volatile" function and gets recalculated every time whenever excel calculates.

Following features have been used while creating this video tutorial:

1. Get Current Date & Time using NOW function
2. Return 6 hours & 12 hours ago date and time
3. Return 7 days and 15 hours future date and time from now
4. Static Current Date & Time using Keyboard Shortcuts


Visit us for daily dose of Excel Tips & Tricks at [ Ссылка ]

In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at [ Ссылка ]

свернуть