Re: I can't get the DatedIf function to work -- returns #value! In D2 and E2 you've text date not excel date. It is not even listed in the "Insert Function" dialog box. No problems with DATEDIF. e. The syntax for the DATEDIF function is: = DATEDIF ( start_date , end_date , unit ) start_date - the first or starting date. To use the DATEDIF function, first enter the two dates into two separate cells. yy) to see 01. Step 2: Click on cell C2 or the cell where you want the result to appear. 🙁. mm. you are done. How is it that the function works, but I can't seem to find it as an available function? Upvote 0. DATEDIF (A1, A3, "D")=. . Instead you would need to use the corresponding serial number: 42320. Examples. Convert. There is a reason that it is hidden. mrdelurk wrote: =DATEDIF (A4,NOW (),"D") (actual example from row 4) The formula calculates the age of a row's entry in days by substracting the date in the first cell (A4) from the current date. If you don't feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue. If you want non-integer precision, you should probably do something simpler without DATEDIF like (A2-A1)*24 or =CONVERT(A2-A1,"day","hr"). You can now use xlDATEDIF just like it was a built-in Excel function. 24. New posts New Excel articles Latest activity. There are three different formulas in order to calculate the years, months and days respectively: In order to calculate the number of years enter the formula of: =DATEDIF (start_date, end_date, “Y”)ฟังก์ชัน DATEDIF. Products (51) Special Topics (28) Video Hub (447) Most Active Hubs. Then you'll get precision down to. The syntax of the DATEDIF function is DATEDIF (start_date,end_date,unit). I searched Excel help and function reference, and MS knowledgebase. To calculate the number of days ignoring blank cells, none of the available functions in Google Sheets has any supporting argument. As you can see, the DATEDIF function returns the # of complete months, while my month - month function returns the number of months "occupied" by the difference between the start and end dates, regardless if they are complete months. Viewed 424 times. So, 31 Jan - 29 Feb will give -zero- months. Pro User. 2251E-308. It calculates the DATE+DIF (where DIF may be inferred as DIFFERENCE) and gives us the output in our preferred unit. If you want a single cell to sum all the individual rows then something like =SUM (IF (DATEDIF (I:I,J:J,"D")>=45,0. The data looks as illustrated below: The formula will be =NETWORKDAYS (B3,C3,D3:D4), giving the result as 43. The "Date" function would work for your purposes. ago. Dim TheDate As Date ' Declare variables. The DATEDIF function is useful in formulas where you need to calculate an age. Package - the zeitraum unit into use when calculating an difference between two dates. Consequently, we will find a difference in months after ignoring the years while calculating. Subtraction will give you the difference in days (those are the units that dates are stored in). Video Tutorial of the Microsoft Excel DATEDIF Functionวิธีการใช้ฟังก์ชั่น. Replied on January 20, 2016. In Excel worksheet, if you want to calculate the number of years, months, days or weeks between two given dates, the DATEDIF function in Excel may help you. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. 1. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur. DATE DATE DAYS. Excel has a 'DATEDIF' function. For example, if you have a start and end date in cells A2 and A3, you can just write = DATEDIF (A2, A3, “d”), which returns the number of days between the two dates. It’s syntax is: =DATEDIF(start_date, end_date, unit) start_date – The start date in Excel serial number format. Menu. I have the. The syntax of of Excel DATEDIF function are as trails: DATEDIF(start_date, end_date, unit) View three arguments are necessary: Start_date - the initial date of the period you wanted go calculate. The first date is specified in cell B4 and the second date in cell C4. Close the parentheses and press Enter. What's new. DATEDIF: The DATEDIF function calculates the difference between two dates in various units, such as days, months, or years. This cell will show the number of days between your specified dates. Click on a cell where you want to add the function and Select “Formulas > Date & Time > NETWORKDAYS. 2. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. There are two options to enter the TODAY function into an Excel worksheet:Excel DATEDIF function explained . That's it. функція. Luckily, it is still there, but you have to know the arguments because Excel won't provide any guidance. 3. The method is not hard. Sintaxe: A sintaxe para o DATEDIF função no Excel é: =DATEDIF(Start_Date, End_Date, Unit) Argumentos:Method #2 – Using DATEDIF Function. DATEVALUE function. Lastly, we will press the Enter key to return the result. When I say available functions, I meant to say DAYS, DATEDIF, NETWORKDAYS, and. e. “y” gets the Years between dates. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). This should give you an answer of 19. This function is available in versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. Before filling out Excel DATEDIF function to get difference between two dates Word form, make sure that you prepared all the required information. So I am wondering if someone can simply add to my existing formula. I think the only version in which DATEDIF appeared in the formula menu (along with HELP for the function), was Excel 2000. These are just the basic applications of the DATEDIF function and it is capable of much more, as demonstrated in the following examples: Excel DATEDIF function - syntax and uses; Count days between two dates; Calculate weeks between the dates; Calculate months between two dates; Compute years between two dates; Date. I'm not actually familiar with this function but see link below - seems that where you have "A" in your formula this is not a valid unit code (i. If you want a static value, use date and time shortcuts. Windows. For example, if you consider the DAYS function, the syntax DAYS(end_date, start_date) has no return_zero_if_blank argument. Step 2: First, we must enter the DATEDIF formula in the first row and use “YD” as a unit in a formula. com) most probably shall be available on all channels for Microsoft 365, includes semi. In Column C, you can write out the following specific formula: =DATEDIF (A3,B3"Y"). I suspect that there are quite a few other functions that are also unavailable. and format the cell as a number. You can vote as helpful, but you cannot reply or subscribe to this thread. I want to calculate dates between dates. I need to see how much he gets paid between. the age) to be completely represented as let’s say “37 Years, 2 months, 14 days”. =end_date-start_date. If you are using Excel 2007, select Microsoft Office Button > Excel Options. INT returns number of work days IN the period, includes start and end date. 78 in this case. The syntax for it is as follows: =DATEDIF (start_date, end_date, unit) DATEDIF takes in three arguments: start_date is the earlier date in the calculation. DATEDIF is "Date & Dif". Dates in Excel work as a number of days since Jan 0, 1900. We'll carry forward the last formula where we added text to the full weeks that passed between the dates in C3 and D3. This means you’ll definitely need to know the format and how to use this function. As a worksheet function, the DATEDIF function can be entered as part of a. 3. 2. Select cell D5 and type the formula below. Excel has had a DATEDIF function for many years. Jon Wittwer September 1, 2017 14 comments. These are the first and second arguments in our function. Notice that the result of this formula is not always similar to the DATEDIF function. Learn how to use this hidden function to quickly calculate the difference between two dates, in days, months, or years. This order will return a positive value. The datepart value cannot be specified in a variable, nor as a quoted string like 'month'. Here's the formula using the DATEDIF function to return the months elapsed between two dates in months and days: =DATEDIF(C3,D3,"M")&"m "&DATEDIF(C3,D3,"MD")&"d". This function is hidden and is not displayed in the Functions menu. Sometimes this function may result in a wrong. To use the DATEDIF function, follow these steps: Open a new or existing Excel worksheet and type the start date in one cell and the end date in another cell. Step 3: Implement the datedif in Excel. The argument list consists of the date and time. “Y” to get the age in years. You can use the following formula to calculate the number of years and months between two dates in Excel: =DATEDIF (A2, B2,"y")&" years "&DATEDIF (A2, B2,"ym")&" months". I have all the Excel-furnished addins installed, but no additional ones. I have searched and tried different things but I just can't seem to make this formula work. I can not find and perform the function. column C has some empty cells. Lisainnj . asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. DATEDIF is an Excel function tailored for this exact task. Well, let me first commend you on a very complicated formula that works. DATEDIF (C3,D3,"M"), the result being 3 months. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution. It creates it using the year in cell E17, and the month in cell E17. We show you how to quickly and easily ana. The DATEDIF function does not directly calculate the number of weeks that are included between two dates. But I wonder why you want to use that function at all. To perform all these calculations, Excel has an incredible function to realize all the different calculation between 2 dates. 19 to 30 Sep is 12 days plus October 30 days = 42 days. C. Sometimes this function may result in a wrong. Alternatively, use the function to compute the difference between any two dates. 1/8/2016 4/7/2016 90. Next, in cell A4 type your formula DATEDIF (A1,A2,”Y”). Step 1: Enter the DOB of a person in the cell. In this example, column D contains the date March 1, 2019 and column E contains the date April 5, 2021. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Syntax: =DATEDIF (start_date, end_date, unit) Start_date : First date in a valid excel format. In the end, hit enter to get the result. =DATEDIF (start,end,unit) Here's the info page at MS for a reference of the units. days, months, years. Nevertheless, the function persists. Enter the start date and end date in their respective cells. Now, you have to find the number of days between the two dates. By default, the weekends indicate Saturday and Sunday. Here's a full list of units you can use: "D" – (short for days) returns the number of days between two dates. 25. . Windows. Devices for education. As a result, the total number of working days returned by Excel is equal to 43. Lastly, we can use the AVERAGE function to determine the average tenure within the data set. ”. INTL (A3,B3,1))) by giving it a name (very similar to naming a range or a cell) and then using. Example 4: When the Day is Not Specified. ago. The DATEDIF Function in Excel. It is the DATEDIF function. DATEDIFF Function. Just enter =D1 - C1-----PS. If your entry doesn’t start with an equal sign, it isn’t a formula, and won’t be calculated—a common mistake. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. Calculating Age in Excel With the DATEDIF function. Products (51) Special Topics (28) Video Hub (447) Most Active Hubs. This function returns the number of whole days, months or years between Start date and End date. Good afternoon, Gurus and Gurettes, I'm working on a much more clumsy, "duct tape-y" solution to my problem and was wondering if someone might offer a more elegant solution in the meantime. Fill in "d" for the third argument to get the number of days between two dates. In reply to BillLohne1's post on April 24, 2023. Office Watch. INT (D5-C5)&” days “ returns the time difference in days. D = days. If you want to calculate months or years rounded up, add half a month or half a year to the formula. TEXT (D5-C5,”h”” hrs “”m”” mins “””) returns the time difference in hours, minutes, and seconds. You accomplish this task by using two DATEDIF functions joined in a text. = (B1-B2)/365. To subtract a date from today in Excel, you can use the TODAY () function and subtraction. Microsoft 365. I am attempting to use the DATEDIF function within an IF statement to tell me the amount of days since I have either applied to a job or followed up. IFERROR checks for the following errors: #N/A, #VALUE!, #. The formula =DATEDIF (start_date, end_date, “m”) compares the dates in A2 (start date) and B2 (end date) and returns the difference in months: Suppose we are given the following dates: The formula used is: The solution we get is: Using the DatedIf function I am. STEP. There's a guy that gets paid an amount per week, That amount is an annual rate divided by 52. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. Therefore, to include the start and end dates in the calculation, adjust the formula accordingly. DateDif: 2. finickyone • 4 yr. Microsoft Teams. This returns the number of years rounded down. Use the DateDiff function in VBA code. Hover the mouse over the lower right edge of the cell until you see the Fill Handle. Example 2: Using Cell References Where Dates are Entered as Text. end_date - the second or last date. Select the cell with the date of birth. Then, enter the following formula into a third cell: =DATEDIF (date1,date2,unit). Since the DATEDIF function is working in Excel but not listed, you can provide the feedback to Product. C. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. Converts a date in the form of text to a serial number. Here’s how to calculate age in Excel using the “ YEARFRAC ” fraction: In a cell, type in the “ equals ” (=) sign and “ INT ” function. Your DATEDIF is generating a number, but I suspect that the cell is formatted to date format, which is presenting the resultant value as a date. The DATEDIF function will return the number of days between two specified dates. DAY function. However, manually counting this adds up to 42 days. In conclusion, the TODAY function is a versatile and useful formula for working with dates in Excel. Dividing 17807 with 365 results in the number of years, 48. thp510 said: I've tried everything. . The syntax is: DATEDIF (start_date, end_date, unit) All arguments. 2) Date calculations involving the last days of a. This formula will calculate the difference between the dates B1 and B2. There are three simple ways how to subtract dates in Excel, they are: Simple subtraction. Right-click on the cell and click Format Cells (or press CTRL+1) and make sure the cell follows the Text format. G. Cell B2 is the End date reference. Now to add the days, the & operator has concatenated the result of the MOD function. The ordinary DATEDIF function returns a single value which can be in terms of years, months or days. –Hi. This formula will return whole weeks and the remaining days: =INT( (D3-C3)/7)&" weeks "&MOD(D3-C3,7)&" days". incase between dates are missing last date minus before date. What are the options for calulating differneces between two dates? Thanks. =DATEDIF(A3, B3, "ym") //difference in months, year component is ignored. Second, let me point you to the newly released LET function, which will enable you to write in a formula only once something like DATEDIF(A3,(B3-((B3-A3)-NETWORKDAYS. Search for the Function you want to use, and select go. “m” gets the between dates. Enter the year in four digits, the month as a number from 1 to 12, and the day as a number from 1 to 31. It always goes wrong when you try to calculate months between two month-ends AND the day in the start date is greater than the day in the end date. Formula: =DATEDIF (C4, TODAY (), "y") Date of birth is the start date in the C4 cell. For example, you might use DateDiff to calculate the number of days between two dates, or the number of weeks between today and the end of the year. In the example shown, the formula in D5, copied down, is: = DATEDIF (B5,C5,"m") Note: DATEDIF automatically rounds down to the nearest whole month. DATEDIF is intended to calculate the length of a. New posts Search forums. After adding the formula, press the Enter button to see the result. replied to. You can find information at Chip Pearson's web site for the DateDif Function – Ron Rosenfeld. DATEDIF ( start_date, end_date, interval ) DATEDIF ( วันเริ่ม, วันจบ, รูปแบบการวัดช่วงเวลา ) โดย interval (รูปแบบการวัดช่วงเวลา) คือ. Important note – Unlike the other functions, the function will not appear as you start to type this date function. The function for calculating the difference (DIF) between two points in time (DATE) is a relic from Lotus 1-2-3, the predecessor to Microsoft Excel. Excel has a 'DATEDIF' function. So if you want other units, you would need to convert the result to the units you want. Outlook. Excel has an incredible function to realize all the different calculation between 2 dates. 2251 is multiplied by 10 raised to the power of -308 (2. In column F, we can use the following variations of the DATEDIF function to calculate the difference in years, months and days respectively. If the start_date is greater than the end_date, the result will be #NUM!. The link below says all about it. في حال كان التاريخ الأول 02-Sep-1 مدخل في الخلية A1، وكان التاريخ الأخير 03-Nov-30 مدخل في الخلية A3، فيمكن استخدام الصيغة الآتية لحساب الفرق بين عدد الأيام مع تجاهل السنوات بين التاريخين. I am trying to correct this formula =DATEDIF(H80,J80,"D")ISBLANK,0)) , where H80 is the start_date, J80 is the end_date, "D" gives me the number of days in between but if one cell is blank to return. e. คํานวณจํานวนวัน เดือน หรือปีระหว่างวันที่สองวัน. 465000" timestamp2 = "2010-01-10-01. finickyone • 4 yr. Dim Msg. Formula DATEDIF tidak terdapat pada fitur auto complete pada Excel. By using the unit options in the DATEDIF function, you can choose the unit of time to calculate the age of the person. Microsoft Excel. The "E-308" part of the notation means "times 10 to the power of -308", so the number 2. Shift+F9. The standard syntax for DATEDIF () function is: =DATEDIF (start_date, end_date, unit) The “unit” argument decides if you want to see the difference in days, months or years etc. for example:Additional Notes. Step 3: Press Enter to get the result, which will be the difference in months between the two dates. Use the DATEDIF function when you want to calculate the difference between two dates. It must be of the same format as the start_date. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH (7,A1:A3,0) returns the number 2, because 7 is the second item in the range. You can also find useful information in this article: Excel DATEDIF function to get difference between two dates. DATEDIF function (microsoft. A formula uses a function that iterates, such as IRR or RATE, and it can’t find a result. The DATEDIF function calculates the number of years between two dates when the interval argument is specified as “Y” as per its syntax, such as; =DATEDIF ( start_date, end_date, “Y” ) When we apply this function with “Y” interval then it calculates years between two dates a complete calendar year without fractional value. STEPS: Choose the cell where you wish the calculated month to appear. Syntax: The syntax for the DATEDIF function in Excel is: =DATEDIF(Start_Date, End_Date, Unit) Arguments:Basis: Use basis 1 which tells Excel to divide the actual number of days per month by the actual number of days per year. If you want to subtract the end date from the start date and return a positive value, then use. sobressair DATEDIF função. Excel. Formula to Get Months Between Two Dates (DATEDIF) First, in cell C2, enter the DATEDIF function. But, I didn't find it listed in the fx place, nor in the HELP place. The DATEDIF function is useful in formulas where you need to calculate an age. Reply. The syntax for the DATEDIF function is: =DATEDIF (Start_Date , End_Date , Unit ) Where the 3 inputs that need to be entered as part of the function are as follows: Start_Date – the first or starting date. And finally, don’t confuse the Excel worksheet function, DATEDIF, with the VBA function DATEDIFF, or the Access DATEDIFF function. e. Luckily, it is still there, but you have to know the arguments because Excel won't provide any guidance. Many Thanks Cheers David . Column A is the application date, and column J. Top Contributors in Excel: HansV MVP - Jim_ Gordon -. This function is available in all versions of Excel but is not documented. The holidays are in F2:F4. DATEDIF. =DATEDIF(A2, A3, "D")In this last example, we are going to utilize yet another Excel date function - DATEDIF(start_date, end_date, interval). ). Make sure that your desired results are also shown (mock up the results manually). To calculate the number of months between two dates as a whole number, you can use the DATEDIF function. Feb 02 2023 04:00 AM. Difference in days This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). Next, the value is relayed to the INT function. Re: missing datedif. To calculate the number of days between date1 and date2, you can use either. Flexible Payments. R. The first argument is the start date. DATEDIF is just designed to return whole numbers. Now you will get the time difference between two dates in days, hours, and minutes. To avoid these unexpected. This function does not appear in the 'Insert Function' dialog box and is not recognised in the 'Function Arguments' dialog box. This formula calculates the total days of service and divides them by 365 days to get a fraction, representing the partial years. See the below given image. If the matter is of calculating a period between two dates, the DATEDIF function serves that exact purpose. DATEDIF. In the above example, Excel DATEDIF function returns the number of years completed between 01 January 1990 and the current date (which is 14 March 2016 in this example). 1) DATEDIF is a weird function. The formula in Cell C2 is: =DAYS (B2,A2) Just like the earlier method, DAYS returns the number of days between two dates. The second argument is the end date. Press Ctrl+1. =DATEDIF(A2, B2, "m") //difference in months. INTL(A3,B3,1))) by giving it a name (very similar to naming a range or. It is not documented and does have some quirks. While excel datedif function include one of the dates that is why its always 1 additional day than python datatime – Eithar. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. 575000" myDiff = DateDiff("s", timestamp1, timestamp2) ' use "s" to get difference in seconds You can find out about the various interval types (seconds in the example above) by looking here for more. Its syntax includes three arguments: start_date, end_date, and unit. you can use Custom format (dd. Here's a list of steps on how to subtract two dates in Excel to find the difference in years: Place your start and end dates into distinct cells. Your result is probably 43 (years), which in a date format (m/d/yyyy) is presented as 2/12/1900. Unit – tells the function to find the number of days (“D”), complete months (“M”), or. The syntax of this function is this: DATEDIF(start_date,end_date,unit) (for more information,. Just make sure these dates in double-quotes is in an accepted date format in Excel. Description. Enter the start_date, end_date, and the desired unit (enclosed in double quotes) within the parentheses. Type the formula =DATEDIF ( in the cell. Jun 22, 2020 at 15:04. It's there, it's just not in the drop-down function list, and the ScreenTip (showing arg options) doesn't show. Second, let me point you to the newly released LET function, which will enable you to write in a formula only once something like DATEDIF (A3, (B3- ( (B3-A3)-NETWORKDAYS. F5=DATEDIF (D5,E5,”y”) // returns 2. This seems so strange. Step 2: Now apply the below code in the command module of VBA. Anyways, let’s see how this formula work. Syntax. Background on what I am trying to achieve: There are two dates in play here,Hi, I would like to calculate the months between 2 dates, but the datedif function does not seem to work in my version Excel (version 16;68). Um die Anzahl der Tage zwischen einzelnen Datumsangaben zu ermitteln, können Sie die DATEDIF-Funktion verwenden: =DATEDIF(B3;C3;"d") Sie können auch einfach die Daten subtrahieren, um die Differenz zwischen den Datumsangaben in Tagen zu ermitteln. intl formula and I can't figure it out. end_date : Second date in a valid excel format. The Excel PowerUps Premium Suite add-in, available on this site, enables an IFS, MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN function (in addition to about 80 other functions) to Excel 2016, Excel 2013, Excel 2010 and Excel 2007. To get the number of months: =DATEDIF(B2, TODAY(), "YM") To get the number of days use the following units:Click in the cell where you want the number of years of service to appear. This computes the number of complete months in the period. As an example, here is the calculation I am trying to make:Here is the formula: =DATEDIF(Date-of-Birth,TODAY(),"md") This will return the rest of the days between the date of birth and today’s date after completing years and months. The unit argument can also be a combination of days, months. 08. There is one older way, the DATEDIF () function, that Microsoft no longer supports. Example 1: Common Uses. The DATEDIF function has three arguments. The DATEDIF function in Excel can be used to calculate the difference between two dates in years, months, days, or hours. This formula works for the days remaining after full months are counted except when the end date month has 30 days and the billed. Syntax: =DATEDIF(Date1, Date2, Interval) According to Chip Pearson, this was documented once, in Excel 2000, but has been in Excel since '95 and is treated like other Formulae's drunk cousin (ie Excel knows it lives a happy and useful life, but will not speak of it in polite conversation. If you want to calculate months or years rounded up, add half a month or >half a year to the formula like this: =DATEDIF(A19,B19+15,”m”) for half a >month (or 15 days) or =DATEDIF(A21,B21+183,”y”) for half a year (or 183 >days). Here, "m" represents months. ฟังก์ชันทุกฟังก์ชันใน Excel สามารถหยิบจับมาใช้งานได้ แต่ไม่ใช่กับ DATEDIF ซึ่งนอกจากเป็นฟังก์ชันแห่งความลับแล้ว ยังถือเป็นฟังก์ชันต้องห้าม!Want all of our free Excel videos? Download our free iPad app at Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified. Formula to sum the output from DATEDIF (X Years X Months X Days). คำเตือน: Excel มีฟังก์ชัน DATEDIF เพื่อสนับสนุนเวิร์กบุ๊กที่เก่ากว่าจาก Lotus 1. 1. To do this, you may have to work out the DATEDIF Function into three different functions. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. For more information about the DATEDIF function, please see Excel DATEDIF - calculate difference between two dates. It is the DATEDIF function. . This is a great function if you work. Now press the ENTER button. 4. Sub DateDiff5 () Dim Msg Msg = "Year Difference: " & DateDiff ("yyyy",. =DATEDIF (B2,C2,"y")&" Years, "&DATEDIF (B2,C2,"ym")&" Months". DATEDIF is an Excel function tailored for this exact task. This formula uses the DATEDIF function to compute the difference between the month’s first and last days. You can specify the time unit of the return value in the unit argument. . Close. If you need to count days between two dates including the start date, this article will help you. unit – is used to tell the function what difference to return. F6=DATEDIF (D6,E6,”m. Can't find any reference to the DATEDIF () function. This time around, we'll calculate the difference in terms of months. The following table lists all the valid datepart values. One use for Excel's DATEDIF function is to calculate a person's current age.