YEAR

Posted on 22-01-2020 , by: admin , in Uncategorized , 0 Comments

Year

What Does It Do?
This function extracts the year number from a date.

Syntax
=YEAR(Date)

Formatting
The result is shown as a number.

Date	Year
#######	1998	=YEAR(C4)

Leave a comment Cancel comment

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}#header-logo a img{height:60px;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.latest-post-selection{display:unset !important;}.latest-post-selection article{width:100% !important;}#footer .wrapper{padding:0 0 0 0px !important;}footer #footer-top #footer-social{padding:0 20px 0 0;}}body #main{margin-top:5px;}.latest-post-selection article{margin-top:10px;margin-left:10px;}::-webkit-scrollbar{width:5px;}::-webkit-scrollbar-track{box-shadow:inset 0 0 5px grey;border-radius:10px;}::-webkit-scrollbar-thumb{background:#00a523;border-radius:10px;}.wrapper{padding:0 0 0 15px;}.latest-post-selection article{margin-top:10px;width:1607%;}.latest-post-selection{display:flex;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.menu-excel-main-container{height:100%;width:330px;position:unset;overflow-y:scroll;}}@media (min-width: 1025px) and (max-width: 3280px){.menu-excel-main-container{height:100%;width:275px;position:fixed;overflow-y:scroll;}}#footer-social h3{color:#207245;}.latest-post-selection article .read-more{padding:8px;float:right;background:#207245;border-radius:4px;color:white;}.latest-post-selection a{color:#207245;}.latest-post-selection article{margin-top:10px;}.breadcrumb-container{margin-top:8px;}.breadcrumb-container ul li a span{position:relative;bottom:8px;}@media (min-width: 1025px) and (max-width: 3280px){#header-navigation:hover{position:unset;width:110%;margin-top:108px;}#header-navigation{position:fixed;width:250px;margin-top:90px;}#main{top:108px;}.exhead-top{width:1155px;position:fixed;background:white;padding-top:10px;padding-bottom:11px;border-bottom:solid 3px green;display:flex;z-index:1;}}nav#site-navigation ul.nav-menu > li > a{font-size:14px !important;}.menu-item-type-post_type a{padding:2px 2px 2px 30px !important;}nav#site-navigation ul.nav-menu > li > a{padding:3px 3px 3px 30px !important;}.copy-the-code-button{background:#00a523 !important;padding:10px 20px !important;cursor:pointer !important;color:#fff !important;font-size:14px !important;font-weight:700 !important;border-radius:2px !important;text-transform:capitalize !important;border:none !important;margin-bottom:3px;}.copy-the-code-button:hover{background:#007233 !important;}.entry-header h2 a{font-weight:700;position:absolute;}.entry-header{display:none;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){#buttonmobo .elementor-top-column:nth-child(2){position:absolute;width:50%;left:50%;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.navbar{display:none !important;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.logo{margin-left:98px !important;}}.navbar-light .navbar-nav .nav-link{color:#207245;font-size:17px;}.bg-light{background-color:#207245 !important;width:75%;margin-left:50px;border-radius:5px;}#navbarNav ul li,ol li{line-height:32px;margin-right:2px;background:gainsboro;border:solid green;border-radius:5px;margin-left:0px;padding:1px 15px;}#navbarNav ul li:hover{background:#00a523;}.navbar-light .navbar-nav .nav-link:hover{color:white;}table,th,td{border:1px solid rgba(158,158,158,.59);}#comments{display:none;}@media (min-width: 481px) and (max-width: 1024px) and (orientation: landscape){.elementor-container .elementor-row .has_ae_slider:first-child .elementor-column-wrap .elementor-widget-wrap .elementor-button-warning .elementor-widget-container{position:absolute;top:20px;}}#masthead img{margin-left:40px;margin-top:5px;}@media (min-width: 1025px) and (max-width: 1980px){#masthead .header #header-logo{display:none;}}#masthead .header #header-logo img{visibility:hidden;}#masthead .header #header-logo .icon_cart_wrap{visibility:hidden;}#masthead .header #header-logo .mobile-search-icon .header a{margin-top:9px;margin-right:15px;}.entry-meta{display:none;}.header-top{display:none;}nav#site-navigation ul.nav-menu li a:hover,nav#site-navigation ul.nav-menu li a:focus{background:#8bc34a;color:#fff;}#main #primary #content article .entry-header{margin-top:15px;}nav#site-navigation ul.nav-menu li#menu-item-13783 a,nav#site-navigation ul.nav-menu li#menu-item-13793 a,nav#site-navigation ul.nav-menu li#menu-item-13788 a{background:#207245;color:white;}nav#site-navigation ul.nav-menu li#menu-item-13904 a,nav#site-navigation ul.nav-menu li#menu-item-14003 a,nav#site-navigation ul.nav-menu li#menu-item-14004 a,nav#site-navigation ul.nav-menu li#menu-item-14005 a,nav#site-navigation ul.nav-menu li#menu-item-14006 a,nav#site-navigation ul.nav-menu li#menu-item-14007 a,nav#site-navigation ul.nav-menu li#menu-item-14008 a,nav#site-navigation ul.nav-menu li#menu-item-14009 a,nav#site-navigation ul.nav-menu li#menu-item-14010 a,nav#site-navigation ul.nav-menu li#menu-item-14800 a,nav#site-navigation ul.nav-menu li#menu-item-14782 a{background:#00a523;color:white;}nav#site-navigation ul.nav-menu li.current-menu-item > a,nav#site-navigation ul.nav-menu li.current-menu-ancestor > a,nav#site-navigation ul.nav-menu li.current-menu-parent > a,nav#site-navigation ul.nav-menu li.current_page_parent > a,nav#site-navigation ul.nav-menu li.current_page_ancestor > a{background:#8bc34a;color:#fff;border-bottom:2px solid #4c7f11;}footer #footer-top #footer-social{background:#207245 !important;}footer #footer-bottom #back_to_top{top:80%;}.menu-excel-main-container ul{margin-bottom:140px !important;}.page-title #breadcrumb-text,.page-title #breadcrumb-text ul li a{font-family:Vollkorn;line-height:22px;font-weight:400;font-style:italic;color:#696969;font-size:15px;}body{background-color:#dfdfdf;}footer #footer-top{background-color:#fff;}footer #footer-bottom{background-color:#fff;}body{font-family:"Roboto Slab";line-height:21px;font-weight:400;font-style:normal;color:#696969;font-size:13px;}h1{font-family:"Roboto Slab";line-height:46.5px;font-weight:700;font-style:normal;color:#000;font-size:21px;}h2{font-family:"Roboto Slab";line-height:22px;font-weight:700;font-style:normal;color:#000;font-size:17px;}h3{font-family:"Roboto Slab";line-height:22px;font-weight:400;font-style:normal;color:#000;font-size:15px;}h4{font-family:"Roboto Slab";line-height:17px;font-weight:400;font-style:normal;color:#343434;font-size:13px;}.breadcrumb-container{font-size:13px;}.breadcrumb-container ul{margin:0;padding:0;}.breadcrumb-container li{box-sizing:unset;display:inline-block;margin:0;padding:0;}.breadcrumb-container li a{box-sizing:unset;padding:0 10px;}.breadcrumb-container{}.breadcrumb-container li a{color:#fff !important;}.breadcrumb-container li .separator{}.breadcrumb-container li:last-child .separator{display:none;}.breadcrumb-container.theme5 li{display:inline-block;margin:0 14px;padding:0;}.breadcrumb-container.theme5 a{background:#007233;color:#666;display:inline-block;font-size:14px;height:16px;margin:0;padding:5px 10px;text-decoration:none;position:relative;}.breadcrumb-container.theme5 a::before{-moz-border-bottom-colors:none;-moz-border-left-colors:none;-moz-border-right-colors:none;-moz-border-top-colors:none;border-color:#007233 #007233 #007233 rgba(0,0,0,0);border-image:none;border-style:solid;border-width:13px;content:" ";display:block;height:0;left:-18px;position:absolute;top:0;width:0;}.breadcrumb-container.theme5 a::after{-moz-border-bottom-colors:none;-moz-border-left-colors:none;-moz-border-right-colors:none;-moz-border-top-colors:none;border-color:rgba(0,0,0,0) rgba(0,0,0,0) rgba(0,0,0,0) #007233;border-image:none;border-style:solid;border-width:13px;content:" ";display:inline-block;height:0;line-height:0;position:absolute;right:-26px;top:0;width:0;}.breadcrumb-container.theme5 .separator{display:none;}.breadcrumb-container{}.breadcrumb-container ul{}.breadcrumb-container li{}.breadcrumb-container a{}.breadcrumb-container .separator{}#lps-1d16bd5b4e07222c81e5c363575349e6 .custom-medium{width:300px;min-height:300px;height:auto;}

YEAR

Year

Leave a comment Cancel comment

LET FUNCTIONS

new excel 3

New excel 2