How to use NOW function in Excel

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

[badenbadenn]

I'm looking for a way to attach =now() to a specific cell, so that it will show the date and time for when this cell was last edited.