WEEKNUM Function - Corporate Finance Institute

The WEEKNUM Function is an Excel DATE and TIME Function. It will return the week number of a specific date. The function will return an integer that ... WEEKNUMFunctionReturnstheweeknumberofaspecificdateHome›Resources›ExcelResources›Functions›WEEKNUMFunctionWhatistheWEEKNUMFunction?TheWEEKNUMFunctionisanExcelDATEandTIMEFunctionFunctionsListofthemostimportantExcelfunctionsforfinancialanalysts.Thischeatsheetcovers100soffunctionsthatarecriticaltoknowasanExcelanalyst.Itwillreturntheweeknumberofaspecificdate.Thefunctionwillreturnanintegerthatrepresentsaweeknumberfrom1to52weeksoftheyear.WEEKNUMisquiteusefulinfinancialanalysisAnalysisofFinancialStatementsHowtoperformAnalysisofFinancialStatements.Thisguidewillteachyoutoperformfinancialstatementanalysisoftheincomestatement,.Supposewewishtodeterminethetimerequiredtocompleteacertainproject,itcanbeusedtoremoveweekendsfromthegiventimeframe.Thus,thefunctionisparticularlyusefulwhenplanningandschedulingworkforbusinessprojects. Formula=WEEKNUM(serial_number,[return_type]) TheWEEKNUMusesthefollowingarguments:Serial_number(requiredargument)–ThisisanExceldateforwhichwewanttoreturntheweeknumber.Whenenteringtheargument,weshouldenterthedateusingtheDATEfunctionorasaresultofotherformulasorfunctions.Return_type(optionalargument)–Thisspecifieswhichnumberingsystemshouldbeusedandwhichdayoftheweekshouldbetreatedasthestartoftheweek.System1–TheweekcontainingJanuary1stisnumberedweek1System2–TheweekcontainingthefirstThursdayoftheyearisnumberedweek1Possiblevaluesare: Return_typeNumberreturned1oromittedItwilltakeSundayasthefirstdayofweek,soSunday=1,Monday=2,...,Saturday=7.Usesnumberingsystem12ItwilltakeMondayasthefirstdayofweek,soMonday=1,Tuesday=2,...,Sunday=7.Usesnumberingsystem111Monday=1,Tuesday=2,...,Sunday=7.Usesnumberingsystem112Tuesday=1,Wednesday=2,...,Monday=7.Usesnumberingsystem113ItwilltakeWednesdayasthefirstdayofweek,soWednesday=1,Thursday=2,...,Tuesday=7.Usesnumberingsystem114ItwilltakeThursdayasfirstdayofweek,soThursday=1,Friday=2,...,Wednesday=7.system115ItshalltakeFridayasfirstdayofweekso,Friday=1,Saturday=2,...,Thursday=7.Usesnumberingsystem116ItwilltakeSaturdayasthefirstdayofweek,Saturday=1,Sunday=2,...,Friday=7.Usesnumberingsystem117Sunday=1,Monday=2,...,Saturday=7.Usesnumberingsystem121WeekrunsfromMondaytoSunday.Usesnumberingsystem2 AfewnotesabouttheWEEKNUMFunctionIfweomitthereturn_typeargument,itwilltakethedefaultvalueof1.MSExcelstoresdatesassequentialserialnumberssotheycanbeusedincalculations.Bydefault,January1,1900isserialnumber1,andJanuary1,2009isserialnumber39448becauseitis39,448daysafterJanuary1,1900.Excelinterpretstextrepresentationsofdatesdifferently,dependingonthedatesettingsonyourcomputer.Therefore,theserial_numberargumentfortheWEEKDAYfunctionshouldbeenteredaseither:AreferencetoacellcontainingadateAdatereturnedfromanotherfunctionorformula HowtousetheWEEKNUMFunctioninExcel?WEEKNUMisabuilt-infunctionthatcanbeusedasaworksheetfunctioninExcel.Tounderstandtheusesofthefunction,let’sconsiderafewexamples: Example1Supposewearegiventhefollowingdates.Let’sseehowwecangettheweeknumberfromthedataset.  Theformulatousewillbe:  Here,wetookthereturn_typeargumentas15,whichmeansitwilltakeFridayasday1oftheweek.Wegettheresultsbelow:   Example2WecanturnaweeknumberintoadateusingtheWEEKNUMfunction.Supposewearegiventhedatabelow:  Forstart_date,theformulatousewillbe:  ItcalculatesthedateofthelastMondayinthepreviousyear.C5*7addsthenumberofweeksmultipliedby7(thenumberofdaysinaweek)togettheMonday(startdate)oftheweekinquestion.Wegettheresultbelow:  Fortheenddate,wewillusethefollowingformula:  Wegettheresultbelow:  TheformulaisbasedontheISOweekdatesystem,wheretheweekstartsonMondayandtheweekcontainingthe1stThursdayoftheyearisconsideredweek1. CommonerrorsinWEEKNUMFunction#VALUE!error–Occurswheneitherthegivenserial_numberisnon-numericorcannotberecognizedasavaliddate.#NUM!error–Occurswhen:Thegivenreturn_typeargumentisnotthevaluepermittedbythefunction.Thegivenserial_numberargumentisnumericbutisoutoftherangeforthecurrentdatebase. ClickheretodownloadthesampleExcelfile AdditionalresourcesThanksforreadingCFI’sguidetotheExcelWEEKNUMfunction.Bytakingthetimetolearnandmasterthesefunctions,you’llsignificantlyspeedupyourfinancialmodeling.Tolearnmore,checkouttheseadditionalCFIresources:ExcelFunctionsforFinanceExcelforFinanceThisExcelforFinanceguidewillteachthetop10formulasandfunctionsyoumustknowtobeagreatfinancialanalystinExcel.AdvancedExcelFormulasCourseAdvancedExcelFormulasYouMustKnowAdvancedExcelFormulasMustKnowTheseadvancedExcelformulasarecriticaltoknowandwilltakeyourfinancialanalysisskillstothenextlevel.DownloadourfreeExcelebook!ExcelShortcutsforPCandMacExcelShortcutsPCMacExcelShortcuts-Listofthemostimportant&commonMSExcelshortcutsforPC&Macusers,finance,accountingprofessions.Keyboardshortcutsspeedupyourmodelingskillsandsavetime.Learnediting,formatting,navigation,ribbon,pastespecial,datamanipulation,formulaandcellediting,andothershortuctsFreeExcelTutorialTomastertheartofExcel,checkoutCFI’sFREEExcelCrashCourse,whichteachesyouhowtobecomeanExcelpoweruser. Learnthemostimportantformulas,functions,andshortcutstobecomeconfidentinyourfinancialanalysis. LaunchCFI’sFreeExcelCoursenowtotakeyourcareertothenextlevelandmoveuptheladder!CorporateFinanceInstituteBacktoWebsite0searchresultsfor‘’Peoplealsosearchfor:excelFreefreecoursesBalancesheetaccountingIRRwaccExploreOurCertificationsFinancialModeling&ValuationAnalyst(FMVA)®LearnmoreCommercialBanking&CreditAnalyst(CBCA)™LearnmoreCapitalMarkets&SecuritiesAnalyst(CMSA)®LearnmoreCertifiedBusinessIntelligence&DataAnalyst(BIDA)™LearnmoreResourcesExcelShortcutsPCMacListofExcelShortcuts Excelshortcuts-Itmayseemsloweratfirstifyou'reusedtothemouse,butit'sworththeinvestmenttotakethetimeand...FreeFinancialModelingGuideACompleteGuidetoFinancialModeling Thisresourceisdesignedtobethebestfreeguidetofinancialmodeling! Wewillbreakdownthemostimportant...SQLDataTypesWhatareSQLDataTypes? TheStructuredQueryLanguage(SQL)comprisesseveraldifferentdatatypesthatallowittostoredifferenttypesofinformation...StructuredQueryLanguage(SQL)WhatisStructuredQueryLanguage(SQL)? StructuredQueryLanguage(SQL)isaspecializedprogramminglanguagedesignedforinteractingwithadatabase....SeeAllResourcesSeeAllPopularCoursesFree!FMVA®-PrepCourses3.5hExcelCrashCourse-SpreadsheetFormulasforFinanceFMVA®-Required5.5hBuildinga3StatementFinancialModelFMVA®-Required7.5hBusinessValuationModelingPartIFMVA®-Required2.5hScenario&SensitivityAnalysisinExcelFMVA®-Required6hDashboards&DataVisualizationFMVA®-Electives11hLeveragedBuyoutLBOModelingSeeAllCoursesSeeAllRecentSearchesSuggestionsFreeCoursesExcelCoursesFinancialModeling&ValuationAnalyst(FMVA)®NameEmailIagreetoCFI’sTermsand ConditionsPleaseverifythatyouareahumanbycompletingtheCAPTCHAtocontinue.TakeAssessmentAlreadyhaveanaccount?Loginhere.