{"id":974,"date":"2019-04-25T16:06:47","date_gmt":"2019-04-25T13:06:47","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=974"},"modified":"2019-04-25T16:06:50","modified_gmt":"2019-04-25T13:06:50","slug":"the-now-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-now-function\/","title":{"rendered":"The NOW Function"},"content":{"rendered":"\n<p>It returns the serial number of the current date and time. <\/p>\n\n\n\n<p>The syntax of the function is the following: <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p> <strong>NOW<\/strong><em>(<\/em>) <\/p><cite> <\/cite><\/blockquote>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=Sk9aYkd1VEcwSlQ5WHNEdzhqWXNaaEdBRmdBYnFQbEJCeEVYdmZNTEIySjY1UjJmZXF4cGxaejNEbHoramtNMg==&b=ZmtpQ3JxTWxyZEo0N3NUUkVoT2FEbzVpNks4Yjloekt2U214bzZXdGpEMStvVUk1aWNBTE0rUkNqWU9sVWV3SUNoa1hKVHlKRDZFVUtzOFJ6ZE5IbXdCcTdaU3M1N3hZOWIwR2trQnZWcTg9\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"><strong>Here are two examples of how to use the NOW function:<\/strong><\/p>\n\n\n\n<p>Format the cell range B1:B10 so that numbers are displayed with 4 decimal places and a thousand separator. Then insert the appropriate function in this cell range to display the difference in days between the date in column A and the current date and time<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/4VJVOEmuVyg?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Insert the appropriate function in the cell A1, to return the current date and time. Insert the appropriate function in the cell A2, to return the current date and time increased by 4 days (+ 4 days). Insert the appropriate function in the cell A3, to return the current date and time increased by 365 days (+ 365 days).<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/XWPq9wL7iUk?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>It returns the serial number of the current date and time. <\/p>\n","protected":false},"author":2,"featured_media":978,"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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[133,136],"class_list":["post-974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-date-time","tag-now"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/now.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-fI","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=974"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/974\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/978"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}