{"id":7423,"date":"2023-01-12T06:08:00","date_gmt":"2023-01-12T00:38:00","guid":{"rendered":"https:\/\/aiyoit.com\/tutorial\/?p=7423"},"modified":"2023-08-30T12:45:59","modified_gmt":"2023-08-30T07:15:59","slug":"date-and-time-formula-in-ms-excel","status":"publish","type":"post","link":"https:\/\/aiyoit.com\/tutorial\/date-and-time-formula-in-ms-excel\/","title":{"rendered":"Date and Time Formula in MS Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7423\" class=\"elementor elementor-7423\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-224bb8d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"224bb8d1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c8c797c\" data-id=\"6c8c797c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-53dbd921 elementor-shape-circle elementor-grid-0 e-grid-align-center elementor-widget elementor-widget-social-icons\" data-id=\"53dbd921\" data-element_type=\"widget\" data-widget_type=\"social-icons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-social-icons.elementor-grid-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-mobile-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-tablet-0 .elementor-widget-container{line-height:1;font-size:0}.elementor-widget-social-icons:not(.elementor-grid-0):not(.elementor-grid-tablet-0):not(.elementor-grid-mobile-0) .elementor-grid{display:inline-grid}.elementor-widget-social-icons .elementor-grid{grid-column-gap:var(--grid-column-gap,5px);grid-row-gap:var(--grid-row-gap,5px);grid-template-columns:var(--grid-template-columns);justify-content:var(--justify-content,center);justify-items:var(--justify-content,center)}.elementor-icon.elementor-social-icon{font-size:var(--icon-size,25px);line-height:var(--icon-size,25px);width:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)));height:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)))}.elementor-social-icon{--e-social-icon-icon-color:#fff;display:inline-flex;background-color:#69727d;align-items:center;justify-content:center;text-align:center;cursor:pointer}.elementor-social-icon i{color:var(--e-social-icon-icon-color)}.elementor-social-icon svg{fill:var(--e-social-icon-icon-color)}.elementor-social-icon:last-child{margin:0}.elementor-social-icon:hover{opacity:.9;color:#fff}.elementor-social-icon-android{background-color:#a4c639}.elementor-social-icon-apple{background-color:#999}.elementor-social-icon-behance{background-color:#1769ff}.elementor-social-icon-bitbucket{background-color:#205081}.elementor-social-icon-codepen{background-color:#000}.elementor-social-icon-delicious{background-color:#39f}.elementor-social-icon-deviantart{background-color:#05cc47}.elementor-social-icon-digg{background-color:#005be2}.elementor-social-icon-dribbble{background-color:#ea4c89}.elementor-social-icon-elementor{background-color:#d30c5c}.elementor-social-icon-envelope{background-color:#ea4335}.elementor-social-icon-facebook,.elementor-social-icon-facebook-f{background-color:#3b5998}.elementor-social-icon-flickr{background-color:#0063dc}.elementor-social-icon-foursquare{background-color:#2d5be3}.elementor-social-icon-free-code-camp,.elementor-social-icon-freecodecamp{background-color:#006400}.elementor-social-icon-github{background-color:#333}.elementor-social-icon-gitlab{background-color:#e24329}.elementor-social-icon-globe{background-color:#69727d}.elementor-social-icon-google-plus,.elementor-social-icon-google-plus-g{background-color:#dd4b39}.elementor-social-icon-houzz{background-color:#7ac142}.elementor-social-icon-instagram{background-color:#262626}.elementor-social-icon-jsfiddle{background-color:#487aa2}.elementor-social-icon-link{background-color:#818a91}.elementor-social-icon-linkedin,.elementor-social-icon-linkedin-in{background-color:#0077b5}.elementor-social-icon-medium{background-color:#00ab6b}.elementor-social-icon-meetup{background-color:#ec1c40}.elementor-social-icon-mixcloud{background-color:#273a4b}.elementor-social-icon-odnoklassniki{background-color:#f4731c}.elementor-social-icon-pinterest{background-color:#bd081c}.elementor-social-icon-product-hunt{background-color:#da552f}.elementor-social-icon-reddit{background-color:#ff4500}.elementor-social-icon-rss{background-color:#f26522}.elementor-social-icon-shopping-cart{background-color:#4caf50}.elementor-social-icon-skype{background-color:#00aff0}.elementor-social-icon-slideshare{background-color:#0077b5}.elementor-social-icon-snapchat{background-color:#fffc00}.elementor-social-icon-soundcloud{background-color:#f80}.elementor-social-icon-spotify{background-color:#2ebd59}.elementor-social-icon-stack-overflow{background-color:#fe7a15}.elementor-social-icon-steam{background-color:#00adee}.elementor-social-icon-stumbleupon{background-color:#eb4924}.elementor-social-icon-telegram{background-color:#2ca5e0}.elementor-social-icon-thumb-tack{background-color:#1aa1d8}.elementor-social-icon-tripadvisor{background-color:#589442}.elementor-social-icon-tumblr{background-color:#35465c}.elementor-social-icon-twitch{background-color:#6441a5}.elementor-social-icon-twitter{background-color:#1da1f2}.elementor-social-icon-viber{background-color:#665cac}.elementor-social-icon-vimeo{background-color:#1ab7ea}.elementor-social-icon-vk{background-color:#45668e}.elementor-social-icon-weibo{background-color:#dd2430}.elementor-social-icon-weixin{background-color:#31a918}.elementor-social-icon-whatsapp{background-color:#25d366}.elementor-social-icon-wordpress{background-color:#21759b}.elementor-social-icon-xing{background-color:#026466}.elementor-social-icon-yelp{background-color:#af0606}.elementor-social-icon-youtube{background-color:#cd201f}.elementor-social-icon-500px{background-color:#0099e5}.elementor-shape-rounded .elementor-icon.elementor-social-icon{border-radius:10%}.elementor-shape-circle .elementor-icon.elementor-social-icon{border-radius:50%}<\/style>\t\t<div class=\"elementor-social-icons-wrapper elementor-grid\">\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-facebook elementor-animation-buzz elementor-repeater-item-01b5564\" href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Facebook<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-facebook\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-instagram elementor-animation-buzz elementor-repeater-item-8a90b95\" href=\"https:\/\/www.instagram.com\/aiyoitns\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Instagram<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-instagram\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-youtube elementor-animation-buzz elementor-repeater-item-567c5bb\" href=\"https:\/\/www.youtube.com\/channel\/UCiagcH73PZUdTzRySS8Axig\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Youtube<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-youtube\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-11ba309 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"11ba309\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-170575a\" data-id=\"170575a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6999247 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"6999247\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:&quot;.comment-container , .smart-post&quot;,&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.10.1 - 09-01-2023 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#a4afb7);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:flex;align-items:center;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#a4afb7)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color)}.elementor-toc__toggle-button{cursor:pointer;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#c2cbd2;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:flex;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe9d686 elementor-widget elementor-widget-heading\" data-id=\"fe9d686\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Date and Time Formula<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71e182f elementor-widget elementor-widget-text-editor\" data-id=\"71e182f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>\u0907\u0938 Option \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 Date \u0914\u0930 Time \u0938\u0947 \u0938\u0902\u092c\u0927\u093f\u0924 Function \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948, \u091c\u093f\u0928\u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0940 Sheet \u092e\u0947\u0902 Date \u0914\u0930 Time \u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06a45ba elementor-widget elementor-widget-heading\" data-id=\"06a45ba\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">TODAY<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aab6af5 elementor-widget elementor-widget-text-editor\" data-id=\"aab6af5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Today Function \u0915\u093e Use Current Date \u092f\u093e Past Date \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-69148d9 elementor-widget elementor-widget-text-editor\" data-id=\"69148d9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Today()<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d925333 elementor-widget elementor-widget-image\" data-id=\"d925333\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"412\" height=\"245\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Today-Formula.png\" class=\"attachment-large size-large wp-image-7543\" alt=\"Today Formula in excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Today-Formula.png 412w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Today-Formula-300x178.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Today-Formula-150x89.png 150w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4763a7 elementor-widget elementor-widget-heading\" data-id=\"e4763a7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">NOW <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f7eab99 elementor-widget elementor-widget-text-editor\" data-id=\"f7eab99\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u093e Use Current Date and Time \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c735f1 elementor-widget elementor-widget-text-editor\" data-id=\"0c735f1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Now()<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90e18ec elementor-widget elementor-widget-image\" data-id=\"90e18ec\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"675\" height=\"303\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Now-Formula.png\" class=\"attachment-large size-large wp-image-7541\" alt=\"Now Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Now-Formula.png 675w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Now-Formula-300x135.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Now-Formula-150x67.png 150w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7aa6402 elementor-widget elementor-widget-heading\" data-id=\"7aa6402\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">DAY <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1ccaa4 elementor-widget elementor-widget-text-editor\" data-id=\"e1ccaa4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u0938\u0947 Day \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0939\u094b\u0924\u094b \u0939\u092e Day Function \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8bfb2f0 elementor-widget elementor-widget-text-editor\" data-id=\"8bfb2f0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Day(serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5f2066 elementor-widget elementor-widget-heading\" data-id=\"f5f2066\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">MONTH <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ab96e8 elementor-widget elementor-widget-text-editor\" data-id=\"0ab96e8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u0938\u0947 Month \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0939\u094b\u0924\u094b \u0939\u092e Month Function \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3ba20e elementor-widget elementor-widget-text-editor\" data-id=\"a3ba20e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Month(serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a57011 elementor-widget elementor-widget-heading\" data-id=\"6a57011\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">YEAR<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b976a68 elementor-widget elementor-widget-text-editor\" data-id=\"b976a68\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Date \u0938\u0947 Year \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0939\u094b\u0924\u094b \u0939\u092e Year Function \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a0f39b elementor-widget elementor-widget-text-editor\" data-id=\"7a0f39b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Year(serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5305faa elementor-widget elementor-widget-heading\" data-id=\"5305faa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">DATE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70dd6fd elementor-widget elementor-widget-text-editor\" data-id=\"70dd6fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Formula \u0915\u093e Use Date \u0928\u093f\u0915\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b227b7c elementor-widget elementor-widget-text-editor\" data-id=\"b227b7c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b><span style=\"font-size: 14.0pt; line-height: 107%; font-family: 'Kokila',sans-serif; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: HI;\">Syntax : =Date(year, month, day)<\/span><\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4db545 elementor-widget elementor-widget-image\" data-id=\"c4db545\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"467\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-1024x467.png\" class=\"attachment-large size-large wp-image-7539\" alt=\"Date Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-1024x467.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-300x137.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-150x68.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-768x350.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula-1536x701.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Date-Formula.png 1859w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8785fbd elementor-widget elementor-widget-heading\" data-id=\"8785fbd\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">HOUR<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f597f3 elementor-widget elementor-widget-text-editor\" data-id=\"8f597f3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u093e Use \u0926\u093f\u092f\u0947 \u0939\u0941\u090f Time \u0938\u0947 Hour \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14f9aaf elementor-widget elementor-widget-text-editor\" data-id=\"14f9aaf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Hour(<\/strong><strong>serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef90698 elementor-widget elementor-widget-heading\" data-id=\"ef90698\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">MINUTE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd48041 elementor-widget elementor-widget-text-editor\" data-id=\"dd48041\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u093e Use \u0926\u093f\u092f\u0947 \u0939\u0941\u090f Time \u0938\u0947 Minute \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38d668d elementor-widget elementor-widget-text-editor\" data-id=\"38d668d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Minute(<\/strong><strong>serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c7d01f elementor-widget elementor-widget-heading\" data-id=\"8c7d01f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SECOND<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6133a46 elementor-widget elementor-widget-text-editor\" data-id=\"6133a46\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u093e Use \u0926\u093f\u092f\u0947 \u0939\u0941\u090f Time \u0938\u0947 Second \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-279635f elementor-widget elementor-widget-text-editor\" data-id=\"279635f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Second(<\/strong><strong>serial_number)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b892c4 elementor-widget elementor-widget-heading\" data-id=\"2b892c4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">TIME<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8511a8c elementor-widget elementor-widget-text-editor\" data-id=\"8511a8c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u093e Use \u0926\u093f\u090f \u0939\u0941\u090f Hour, Minute and Second \u0938\u0947 Time \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-010af7f elementor-widget elementor-widget-text-editor\" data-id=\"010af7f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Time(hour, minute, second)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4180a3 elementor-widget elementor-widget-image\" data-id=\"a4180a3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"316\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-1024x316.png\" class=\"attachment-large size-large wp-image-7542\" alt=\"Time Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-1024x316.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-300x93.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-150x46.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-768x237.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-1536x474.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Time-Formula-2048x633.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90aebcf elementor-widget elementor-widget-heading\" data-id=\"90aebcf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">DATEDIF<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cc3f6d elementor-widget elementor-widget-text-editor\" data-id=\"5cc3f6d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0926\u094b Dates \u0915\u0947 \u092c\u0940\u091a Day, Month \u092f\u093e Year \u0915\u0940 Number \u0915\u0940 Calculation \u0915\u0930\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ebbae89 elementor-widget elementor-widget-text-editor\" data-id=\"ebbae89\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Datedif(start_date, end_date, unit)<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d72cff4 elementor-widget elementor-widget-image\" data-id=\"d72cff4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"347\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-1024x347.png\" class=\"attachment-large size-large wp-image-7540\" alt=\"Dated IF Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-1024x347.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-300x102.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-150x51.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-768x260.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-1536x521.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Dated-IF-Formula-2048x694.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-a49ba01 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a49ba01\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-96e1217\" data-id=\"96e1217\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3e16647f elementor-widget elementor-widget-text-editor\" data-id=\"3e16647f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0928\u094d\u0939\u0947 \u092d\u0940 \u092a\u095d\u0947 &#8212;-<br \/>&gt;<a href=\"https:\/\/aiyoit.com\/tutorial\/what-is-the-use-of-data-tab-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Data Tab in Excel in Hindi<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/logical-function-and-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/the-text-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Text Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/lookup-formula-reference-in-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Lookup and Reference Formula in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/financial-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Formula in Excel<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-6efc8237 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6efc8237\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-44999b77\" data-id=\"44999b77\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14edcc4c elementor-widget elementor-widget-text-editor\" data-id=\"14edcc4c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p class=\"has-background\"><em>\u0906\u0936\u093e \u0915\u0930\u0924\u093e \u0939\u0942\u0901 \u0915\u0940 \u0907\u0938 Article \u0938\u0947 \u0906\u092a\u0915\u094b Date and Time Formula \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u093f\u0932\u0940 \u0939\u094b\u0917\u0940, \u0905\u0917\u0930 \u0906\u092a \u0915\u094b Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0915\u0941\u091b \u0938\u092e\u091d \u092e\u0947\u0902 \u0906\u092f\u093e \u0939\u094b \u0924\u094b \u0905\u092a\u0928\u0947 \u0926\u094b\u0938\u094d\u0924\u094b\u0902 \u0915\u0947 \u092a\u093e\u0938 \u091c\u0930\u0942\u0930 Share \u0915\u0930\u0947 \u0924\u093e\u0915\u093f \u0909\u0928\u0915\u094b \u092d\u0940\u00a0 Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 knowledge \u092e\u093f\u0932 \u0938\u0915\u0947\u0964 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947 <strong><a href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\" rel=\"noreferrer noopener\">Facebook Page<\/a>\u00a0<\/strong>\u0915\u094b Follow \u0914\u0930\u00a0<strong><a href=\"https:\/\/www.youtube.com\/@aiyoit5339\/featured\" target=\"_blank\" rel=\"noreferrer noopener\">Youtube channel<\/a>\u00a0<\/strong>\u0915\u094b subscribe \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0905\u0917\u0930 \u0906\u092a \u0915\u093e \u0915\u094b\u0908 \u0938\u0935\u093e\u0932 \u0939\u094b \u0924\u094b comment box \u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947\u0964<\/em><\/p><p><strong>Thank You !<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-1cf388b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1cf388b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2a095233\" data-id=\"2a095233\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a2836f elementor-widget elementor-widget-eael-content-ticker\" data-id=\"9a2836f\" data-element_type=\"widget\" data-widget_type=\"eael-content-ticker.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"eael-ticker-wrap\" id=\"eael-ticker-wrap-9a2836f\"><div class=\"ticker-badge\">\n                    <span>Trending Today<\/span>\n                <\/div><div class=\"swiper-container-wrap eael-ticker\">\n                <div class=\"swiper-container eael-content-ticker swiper-container-9a2836f\" data-pagination=\".swiper-pagination-9a2836f\" data-arrow-next=\".swiper-button-next-9a2836f\" data-arrow-prev=\".swiper-button-prev-9a2836f\" data-effect=\"slide\" data-speed=\"400\" data-autoplay=\"2000\" data-loop=\"1\" data-arrows=\"1\">\n                    <div class=\"swiper-wrapper\"><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upsi-gs-hindi-100-questions-quiz\/\" class=\"ticker-content-link\">UPSI GS &#038; Hindi &#8211; 100 Questions Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upp-quiz-questions-100\/\" class=\"ticker-content-link\">UPP Quiz Questions 100<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-photoshop-internet-test-quiz\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally, Photoshop, Internet -Test Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-test-quiz-2\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally &#8211; Test Quiz<\/a>\n        <\/div>\n    <\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"content-ticker-pagination\"><div class=\"swiper-button-next swiper-button-next-9a2836f\"><i class=\"fas fa-angle-right\"><\/i><\/div><div class=\"swiper-button-prev swiper-button-prev-9a2836f\"><i class=\"fas fa-angle-left\"><\/i><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-5e00d3ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e00d3ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3cf2a016\" data-id=\"3cf2a016\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-842acfb elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"842acfb\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-share-buttons.min.css\">\t\t<div class=\"elementor-grid\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_facebook\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on facebook\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_pinterest\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on pinterest\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-pinterest\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tPinterest\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_linkedin\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on linkedin\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-linkedin\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_whatsapp\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on whatsapp\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-whatsapp\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0907\u0938 Option \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 Date \u0914\u0930 Time \u0938\u0947 \u0938\u0902\u092c\u0927\u093f\u0924 Function \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948, \u091c\u093f\u0928\u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0940 Sheet \u092e\u0947\u0902 Date \u0914\u0930 Time \u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n","protected":false},"author":6,"featured_media":7459,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[44],"tags":[1796,9,985,497,1790,1798,1791,1785,1794,1795,1755,1788,1786,1505,1793,1792,1797,1789],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7423"}],"collection":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7423"}],"version-history":[{"count":16,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7423\/revisions"}],"predecessor-version":[{"id":7623,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7423\/revisions\/7623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media\/7459"}],"wp:attachment":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/categories?post=7423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}