{"id":64,"date":"2012-06-22T08:00:00","date_gmt":"2012-06-22T08:00:00","guid":{"rendered":"http:\/\/www.ahbsolutions.co.uk\/blog\/?p=64"},"modified":"2017-03-29T14:46:18","modified_gmt":"2017-03-29T14:46:18","slug":"inserting-the-date-and-time-into-a-worksheet","status":"publish","type":"post","link":"https:\/\/www.ahbtraining.co.uk\/blog\/2012\/06\/inserting-the-date-and-time-into-a-worksheet\/","title":{"rendered":"Inserting the Date and Time into a Worksheet"},"content":{"rendered":"

\"excellogo\"<\/a>It happens often, current date and\/or time is to be added to a worksheet, perhaps while making a time stamped log of activities. Maybe there is a requirements to have the current data or time displayed automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and time in a cell.<\/p>\n

Insert a Static Date or Time<\/h2>\n

A static value in a worksheet remains constant when the worksheet is recalculated or opened. Excel can insert the current data or time as a static value in a call, in order to do this Excel \u201ctakes a snapshot\u201d of the current date and then inserts the value in the cell. That cell\u2019s value doesn\u2019t change, so it\u2019s considered static.<\/p>\n

The following key combinations allow inserting of the current date and time<\/p>\n\n\n\n\n\n
Insert current date<\/td>\nCtrl + ; (semi-colon)<\/td>\n<\/tr>\n
Insert current time<\/td>\nCtrl + Shift + ; (semi-colon)<\/td>\n<\/tr>\n
Insert current date and time<\/td>\nCtrl + ; (semi-colon) then by Space Bar, then Ctrl + Shift + ; (semi-colon)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Insert an Updating Date or Time<\/h2>\n

A dynamic value is one where the value is recalculated or updated when the worksheet is recalculated or opened. A date or time can be a dynamic value by using a function to return the date or time.<\/p>\n

To insert the current date or time so that it is updatable, use the TODAY<\/strong> and NOW<\/strong> functions.<\/p>\n\n\n\n\n
=TODAY()<\/td>\nCurrent date (varies)<\/td>\n<\/tr>\n
=NOW()<\/td>\nCurrent date and time (varies)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note <\/strong>The results of the TODAY<\/strong> and NOW<\/strong> functions change only when the worksheet is calculated or when a macro that contains the function is run. Cells that contain these functions are not updated continuously. The date and time values that are used are taken from the computer’s system clock.<\/p>\n","protected":false},"excerpt":{"rendered":"

It happens often, current date and\/or time is to be added to a worksheet, perhaps while making a time stamped log of activities. Maybe there is a requirements to have the current data or time displayed automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[29,22],"tags":[54,84,90,124,136,137],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-excel-2007","category-tips-and-tricks","tag-date","tag-keyboard","tag-microsoft-excel","tag-shortcuts","tag-time","tag-tips","item-wrap"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":1,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":467,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions\/467"}],"wp:attachment":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}