{"id":1177,"date":"2018-07-01T15:13:53","date_gmt":"2018-07-01T15:13:53","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1177"},"modified":"2023-11-03T10:43:27","modified_gmt":"2023-11-03T10:43:27","slug":"now","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/now\/","title":{"rendered":"NOW function"},"content":{"rendered":"\n
The Excel NOW function returns the current date and time in a cell. It’s a handy tool for tracking when you last updated a document, calculating time intervals, or creating timestamps.<\/p>\n\n\n\n
NOW()<\/strong><\/p>\n\n\n\n To use the Excel NOW function, follow these steps:<\/p>\n\n\n\n 1. Open an Excel spreadsheet where you want to insert the current date and time.<\/p>\n\n\n\n 2. Click on the cell where you want the date and time to appear.<\/p>\n\n\n\n 3. In the cell, type the following formula:<\/p>\n\n\n\n This formula does not require any arguments; it simply retrieves the current date and time.<\/p>\n\n\n\n 4. Press Enter, and the cell will display the current date and time in the default date and time format.<\/p>\n\n\n\n Examples:<\/p>\n\n\n\n Let’s look at some examples of using the Excel NOW function:<\/p>\n\n\n\n Example 1:<\/strong> Insert the current date and time in cell A1.<\/p>\n\n\n\n This formula will display the current date and time in cell A1.<\/p>\n\n\n\n Example 2:<\/strong> Calculate the time difference between two dates.<\/p>\n\n\n\n Suppose you have two dates in cells A1 and B1, and you want to calculate the time difference in hours. You can use a formula like this:<\/p>\n\n\n\n This formula subtracts the date and time in cell A1 from the date and time in cell B1, giving you the time difference in hours.<\/p>\n\n\n\n Example 3:<\/strong> Automatically update a “Last Updated” timestamp.<\/p>\n\n\n\n If you want to track the last time you updated a document, you can place the NOW function in a specific cell, like A1:<\/p>\n\n\n\n Now, every time you open the document or make changes, the cell with the NOW function will update to the current date and time.<\/p>\n\n\n\n Keep in mind that the NOW function continuously updates whenever Excel recalculates. If you need a static timestamp, you should copy and paste the value as needed.<\/p>\n","protected":false},"excerpt":{"rendered":" The Excel NOW function returns the current date and time in a cell. It’s a handy tool for tracking when you last updated…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
None<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=NOW()<\/code><\/pre>\n\n\n\n
=NOW()<\/code><\/pre>\n\n\n\n
=B1 - A1<\/code><\/pre>\n\n\n\n
=NOW()<\/code><\/pre>\n\n\n\n