{"id":85118,"date":"2025-11-20T14:35:00","date_gmt":"2025-11-20T14:35:00","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/"},"modified":"2025-11-20T14:35:00","modified_gmt":"2025-11-20T14:35:00","slug":"20-excel-date-and-time-functions-quiz-questions-and-answers","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/","title":{"rendered":"20 Excel Date and Time Functions Quiz Questions and Answers"},"content":{"rendered":"<p>Excel offers a range of built-in functions for managing dates and times, allowing users to perform calculations, extractions, and manipulations efficiently. Below is a concise summary of the primary functions:<\/p>\n<p>&#8211; TODAY(): Returns the current date. Example: =TODAY() displays today&#8217;s date.<br \/>\n&#8211; NOW(): Returns the current date and time. Example: =NOW() shows the full current datetime.<br \/>\n&#8211; DATE(year, month, day): Creates a date from specified year, month, and day values. Example: =DATE(2023, 12, 31) returns December 31, 2023.<br \/>\n&#8211; TIME(hour, minute, second): Creates a time from specified hour, minute, and second values. Example: =TIME(14, 30, 0) returns 2:30 PM.<br \/>\n&#8211; YEAR(serial_number): Extracts the year from a date. Example: =YEAR(&#8220;12\/31\/2023&#8221;) returns 2023.<br \/>\n&#8211; MONTH(serial_number): Extracts the month from a date. Example: =MONTH(&#8220;12\/31\/2023&#8221;) returns 12.<br \/>\n&#8211; DAY(serial_number): Extracts the day from a date. Example: =DAY(&#8220;12\/31\/2023&#8221;) returns 31.<br \/>\n&#8211; HOUR(serial_number): Extracts the hour from a time. Example: =HOUR(&#8220;14:30:00&#8221;) returns 14.<br \/>\n&#8211; MINUTE(serial_number): Extracts the minute from a time. Example: =MINUTE(&#8220;14:30:00&#8221;) returns 30.<br \/>\n&#8211; SECOND(serial_number): Extracts the second from a time. Example: =SECOND(&#8220;14:30:15&#8221;) returns 15.<br \/>\n&#8211; DATEDIF(start_date, end_date, &#8220;unit&#8221;): Calculates the difference between two dates in specified units (e.g., &#8220;Y&#8221; for years, &#8220;M&#8221; for months, &#8220;D&#8221; for days). Example: =DATEDIF(&#8220;1\/1\/2023&#8221;, &#8220;12\/31\/2023&#8221;, &#8220;D&#8221;) returns the number of days between the dates.<br \/>\n&#8211; EDATE(start_date, months): Returns a date that is a specified number of months before or after the start date. Example: =EDATE(&#8220;12\/31\/2023&#8221;, 1) returns January 31, 2024.<br \/>\n&#8211; EOMONTH(start_date, months): Returns the last day of the month that is a specified number of months before or after the start date. Example: =EOMONTH(&#8220;1\/15\/2023&#8221;, 0) returns January 31, 2023.<br \/>\n&#8211; NETWORKDAYS(start_date, end_date, [holidays]): Calculates the number of working days (excluding weekends and optional holidays) between two dates. Example: =NETWORKDAYS(&#8220;1\/1\/2023&#8221;, &#8220;1\/31\/2023&#8221;) returns the working days in January 2023.<br \/>\n&#8211; WEEKDAY(serial_number, [return_type]): Returns the day of the week corresponding to a date. Example: =WEEKDAY(&#8220;1\/1\/2023&#8221;) returns 1 for Sunday.<br \/>\n&#8211; WORKDAY(start_date, days, [holidays]): Returns a date that is a specified number of working days ahead or before the start date. Example: =WORKDAY(&#8220;1\/1\/2023&#8221;, 5) returns the date 5 working days after January 1, 2023.<\/p>\n<p>These functions can be combined for more complex operations, such as calculating age, scheduling, or analyzing time-based data. Always ensure dates are entered in a format recognized by Excel for accurate results.<\/p>\n<h3>Table of Contents<\/h3>\n<ul class=\"article_list\">\n<li><a href=\"#1\">Part 1: OnlineExamMaker AI Quiz Generator &#8211; The Easiest Way to Make Quizzes Online<\/a><\/li>\n<li><a href=\"#2\">Part 2: 20 Excel Date and Time Functions Quiz Questions &#038; Answers<\/a><\/li>\n<li><a href=\"#3\">Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic <\/a><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2909-Excel-Date-andTime-Functions-quiz.webp\" alt=\"\"\/><\/p>\n<h3 id=\"1\">Part 1: OnlineExamMaker AI Quiz Generator &#8211; The Easiest Way to Make Quizzes Online<\/h3>\n<p>When it comes to ease of creating a Excel Date and Time Functions skills assessment, OnlineExamMaker is one of the best AI-powered quiz making software for your institutions or businesses. With its AI Question Generator, just upload a document or input keywords about your assessment topic, you can generate high-quality quiz questions on any topic, difficulty level, and format.<\/p>\n<p><strong>What you will like:<\/strong><br \/>\n\u25cf AI Question Generator to help you save time in creating quiz questions automatically.<br \/>\n\u25cf Share your online exam with audiences on social platforms like Facebook, Twitter, Reddit and more.<br \/>\n\u25cf Display the feedback for correct or incorrect answers instantly after a question is answered.<br \/>\n\u25cf Create a lead generation form to collect an exam taker&#8217;s information, such as email, mobile phone, work title, company profile and so on. <\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Automatically generate questions using AI<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">Try AI Question Generator<\/a><\/div>\n<div class=\"p-style-b\">Generate questions for any topic<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Create A Quiz<\/a><\/div>\n<div class=\"p-style-b\">100% free forever<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 id=\"2\">Part 2: 20 Excel Date and Time Functions Quiz Questions &#038; Answers<\/h3>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">Copy Quiz Questions<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">Generate Questions using AI<\/button><\/p>\n<div id=\"copy_questions\">\n<p>Question 1:<br \/>\nWhat function returns the current date in Excel?<br \/>\nA) TODAY()<br \/>\nB) NOW()<br \/>\nC) DATE()<br \/>\nD) TIME()<br \/>\nAnswer: A) TODAY()<br \/>\nExplanation: TODAY() returns the current date without the time component.<\/p>\n<p>Question 2:<br \/>\nWhich function returns both the current date and time?<br \/>\nA) TODAY()<br \/>\nB) DATE()<br \/>\nC) NOW()<br \/>\nD) TIME()<br \/>\nAnswer: C) NOW()<br \/>\nExplanation: NOW() returns the current date and time based on the system clock.<\/p>\n<p>Question 3:<br \/>\nWhat is the purpose of the DATE() function?<br \/>\nA) To add dates<br \/>\nB) To return the current time<br \/>\nC) To create a date from year, month, and day values<br \/>\nD) To calculate the difference between dates<br \/>\nAnswer: C) To create a date from year, month, and day values<br \/>\nExplanation: DATE(year, month, day) constructs a date serial number from the specified components.<\/p>\n<p>Question 4:<br \/>\nHow does the TIME() function work?<br \/>\nA) It returns the current date<br \/>\nB) It creates a time from hour, minute, and second values<br \/>\nC) It adds time to a date<br \/>\nD) It calculates the total seconds in a day<br \/>\nAnswer: B) It creates a time from hour, minute, and second values<br \/>\nExplanation: TIME(hour, minute, second) builds a time value that can be used in calculations.<\/p>\n<p>Question 5:<br \/>\nWhat does the YEAR() function extract from a date?<br \/>\nA) The month<br \/>\nB) The day<br \/>\nC) The year<br \/>\nD) The hour<br \/>\nAnswer: C) The year<br \/>\nExplanation: YEAR(serial_number) extracts the year portion (e.g., 2023) from a given date.<\/p>\n<p>Question 6:<br \/>\nWhich function is used to extract the month from a date?<br \/>\nA) MONTH()<br \/>\nB) DAY()<br \/>\nC) YEAR()<br \/>\nD) EOMONTH()<br \/>\nAnswer: A) MONTH()<br \/>\nExplanation: MONTH(serial_number) returns the month number (1-12) from a date.<\/p>\n<p>Question 7:<br \/>\nWhat does the DAY() function do?<br \/>\nA) Returns the day of the week<br \/>\nB) Extracts the day of the month from a date<br \/>\nC) Adds days to a date<br \/>\nD) Calculates the total days in a year<br \/>\nAnswer: B) Extracts the day of the month from a date<br \/>\nExplanation: DAY(serial_number) returns the day of the month (1-31) from a date value.<\/p>\n<p>Question 8:<br \/>\nHow is the HOUR() function used?<br \/>\nA) To get the hour from a time value<br \/>\nB) To add hours to a date<br \/>\nC) To return the total hours in a day<br \/>\nD) To convert time to seconds<br \/>\nAnswer: A) To get the hour from a time value<br \/>\nExplanation: HOUR(serial_number) extracts the hour (0-23) from a time or datetime value.<\/p>\n<p>Question 9:<br \/>\nWhat does MINUTE() function return?<br \/>\nA) The minute from a time value<br \/>\nB) The total minutes in an hour<br \/>\nC) The month from a date<br \/>\nD) The second from a time value<br \/>\nAnswer: A) The minute from a time value<br \/>\nExplanation: MINUTE(serial_number) returns the minute (0-59) from a time or datetime.<\/p>\n<p>Question 10:<br \/>\nWhich function extracts the second from a time?<br \/>\nA) SECOND()<br \/>\nB) MINUTE()<br \/>\nC) HOUR()<br \/>\nD) TIME()<br \/>\nAnswer: A) SECOND()<br \/>\nExplanation: SECOND(serial_number) returns the second (0-59) from a time or datetime value.<\/p>\n<p>Question 11:<br \/>\nWhat is the function to find the last day of the month?<br \/>\nA) EOMONTH()<br \/>\nB) EDATE()<br \/>\nC) TODAY()<br \/>\nD) DATE()<br \/>\nAnswer: A) EOMONTH()<br \/>\nExplanation: EOMONTH(start_date, months) returns the last day of the month after a specified number of months.<\/p>\n<p>Question 12:<br \/>\nHow does EDATE() work?<br \/>\nA) Adds or subtracts months from a date<br \/>\nB) Adds days to a date<br \/>\nC) Returns the current date<br \/>\nD) Calculates the difference in dates<br \/>\nAnswer: A) Adds or subtracts months from a date<br \/>\nExplanation: EDATE(start_date, months) returns a date that is a specified number of months before or after the start date.<\/p>\n<p>Question 13:<br \/>\nWhat does DATEDIF() calculate?<br \/>\nA) The difference between two dates in various units like days or years<br \/>\nB) The sum of dates<br \/>\nC) The average of dates<br \/>\nD) The current date<br \/>\nAnswer: A) The difference between two dates in various units like days or years<br \/>\nExplanation: DATEDIF(start_date, end_date, &#8220;unit&#8221;) computes the difference between two dates, such as &#8220;Y&#8221; for years or &#8220;D&#8221; for days.<\/p>\n<p>Question 14:<br \/>\nWhich function calculates the number of workdays between two dates?<br \/>\nA) NETWORKDAYS()<br \/>\nB) WORKDAY()<br \/>\nC) DATEDIF()<br \/>\nD) TODAY()<br \/>\nAnswer: A) NETWORKDAYS()<br \/>\nExplanation: NETWORKDAYS(start_date, end_date, [holidays]) returns the number of working days, excluding weekends and optional holidays.<\/p>\n<p>Question 15:<br \/>\nWhat is the purpose of the WORKDAY() function?<br \/>\nA) To return a date that is a specified number of workdays from a start date<br \/>\nB) To add regular days to a date<br \/>\nC) To calculate total work hours<br \/>\nD) To get the current workday<br \/>\nAnswer: A) To return a date that is a specified number of workdays from a start date<br \/>\nExplanation: WORKDAY(start_date, days, [holidays]) adds workdays to a date, skipping weekends and holidays.<\/p>\n<p>Question 16:<br \/>\nHow does the TEXT() function relate to dates?<br \/>\nA) It formats a date or time as text in a specified format<br \/>\nB) It converts text to a date<br \/>\nC) It adds text to a date<br \/>\nD) It extracts text from a date<br \/>\nAnswer: A) It formats a date or time as text in a specified format<br \/>\nExplanation: TEXT(value, format_text) converts a date or time into a text string with the desired format, like &#8220;dd\/mm\/yyyy&#8221;.<\/p>\n<p>Question 17:<br \/>\nWhat does the WEEKNUM() function do?<br \/>\nA) Returns the week number of the year for a given date<br \/>\nB) Calculates the total weeks in a year<br \/>\nC) Adds weeks to a date<br \/>\nD) Returns the day of the week<br \/>\nAnswer: A) Returns the week number of the year for a given date<br \/>\nExplanation: WEEKNUM(serial_number, [return_type]) gives the week number (1-52 or 53) based on the date.<\/p>\n<p>Question 18:<br \/>\nWhich function is used to get the weekday from a date?<br \/>\nA) WEEKDAY()<br \/>\nB) DAY()<br \/>\nC) WEEKNUM()<br \/>\nD) MONTH()<br \/>\nAnswer: A) WEEKDAY()<br \/>\nExplanation: WEEKDAY(serial_number, [return_type]) returns a number representing the day of the week (e.g., 1 for Sunday).<\/p>\n<p>Question 19:<br \/>\nHow can you use the DATEVALUE() function?<br \/>\nA) To convert a date entered as text to a serial number<br \/>\nB) To add values to a date<br \/>\nC) To get the current date value<br \/>\nD) To subtract dates<br \/>\nAnswer: A) To convert a date entered as text to a serial number<br \/>\nExplanation: DATEVALUE(date_text) converts a date string (like &#8220;1\/1\/2023&#8221;) into an Excel date serial number.<\/p>\n<p>Question 20:<br \/>\nWhat is the role of the TIMEVALUE() function?<br \/>\nA) To convert a time entered as text to a time serial number<br \/>\nB) To add time values<br \/>\nC) To get the current time value<br \/>\nD) To calculate time differences<br \/>\nAnswer: A) To convert a time entered as text to a time serial number<br \/>\nExplanation: TIMEVALUE(time_text) changes a time string (like &#8220;14:30&#8221;) into an Excel time serial number.<\/p>\n<\/div>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">Copy Quiz Questions<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">Generate Questions using AI<\/button><\/p>\n<h3 id=\"3\">Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic<\/h3>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Automatically generate questions using AI<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">Try AI Question Generator<\/a><\/div>\n<div class=\"p-style-b\">Generate questions for any topic<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> Create A Quiz<\/a><\/div>\n<div class=\"p-style-b\">100% free forever<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><script src=\"https:\/\/unpkg.com\/@popperjs\/core@2\"><\/script><br \/>\n<script src=\"https:\/\/unpkg.com\/tippy.js@6\"><\/script><\/p>\n<p><script type=\"text\/javascript\">\nfunction myFunction() {\nvar copyText = document.getElementById(\"copy_questions\");console.log(copyText.innerText);navigator.clipboard.writeText(copyText.innerText);\n}\nfunction myFunction1() {\n\u00a0  \u00a0 \u00a0 window.open(\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html\");\n\u00a0 }\nvar copy1, copy2;\n        tippy('#copyquestionsBtn', {\n        'content': \"Copy questions to clipboard\",\n       trigger: 'mouseenter',\n       'onCreate':function(instance){\n              copy1 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy2.hide();\n       }\n       });\n       tippy('#copyquestionsBtn', {\n       'content': \"Copied successfully\",\n       trigger: 'click',\n       'onCreate':function(instance){\n              copy2 = instance;\n       },\n       'onTrigger' : function(instance, event) {\n              copy1.hide();\n       }\n       });\ntippy('#genquestionsBtn', {\n        'content': \"Generate questions using AI for free\",\n         trigger: 'mouseenter'\n       });\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel offers a range of built-in functions for managing dates and times, allowing users to perform calculations, extractions, and manipulations efficiently. Below is a concise summary of the primary functions: &#8211; TODAY(): Returns the current date. Example: =TODAY() displays today&#8217;s date. &#8211; NOW(): Returns the current date and time. Example: =NOW() shows the full current [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":84994,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[353],"tags":[],"class_list":["post-85118","post","type-post","status-publish","format-standard","hentry","category-questions-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Excel offers a range of built-in functions for managing dates and times, allowing users to perform calculations, extractions, and manipulations efficiently. Below is a concise summary of the primary functions: &#8211; TODAY(): Returns the current date. Example: =TODAY() displays today&#8217;s date. &#8211; NOW(): Returns the current date and time. Example: =NOW() shows the full current [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-20T14:35:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2909-Excel-Date-andTime-Functions-quiz.webp\" \/>\n<meta name=\"author\" content=\"Rebecca\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rebecca\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/\",\"name\":\"20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2025-11-20T14:35:00+00:00\",\"dateModified\":\"2025-11-20T14:35:00+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"20 Excel Date and Time Functions Quiz Questions and Answers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\",\"name\":\"Rebecca\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"caption\":\"Rebecca\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/","og_locale":"en_US","og_type":"article","og_title":"20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog","og_description":"Excel offers a range of built-in functions for managing dates and times, allowing users to perform calculations, extractions, and manipulations efficiently. Below is a concise summary of the primary functions: &#8211; TODAY(): Returns the current date. Example: =TODAY() displays today&#8217;s date. &#8211; NOW(): Returns the current date and time. Example: =NOW() shows the full current [&hellip;]","og_url":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2025-11-20T14:35:00+00:00","og_image":[{"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2026\/01\/2909-Excel-Date-andTime-Functions-quiz.webp"}],"author":"Rebecca","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rebecca","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/","url":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/","name":"20 Excel Date and Time Functions Quiz Questions and Answers - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2025-11-20T14:35:00+00:00","dateModified":"2025-11-20T14:35:00+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2"},"breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/20-excel-date-and-time-functions-quiz-questions-and-answers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"20 Excel Date and Time Functions Quiz Questions and Answers"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2","name":"Rebecca","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","caption":"Rebecca"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/85118"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=85118"}],"version-history":[{"count":0,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/85118\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/84994"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=85118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=85118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=85118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}