=DATEDIF (A1;B1;"M") does not work, returns "1900-01-03" but should return "3" (jan+feb+mar). It's fallen off current Excel menus, but you can still use it. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. Then type a formula like one of the following. And again, 12/31/2019 is after that. Thus, to write a formula that will calculate age in Excel, open Excel and obey the following steps: Enter the Birthdate in one cell, cell B3 for example (See screenshot below) Enter =Today () function in another cell, cell C3 (see screenshot below). Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏. Using DATEDIF Function in Excel: Excel DATEDIF function can be used when you want to calculate the number of years, months, or days between the two specified dates. 2251E-308. Cell A2 is the Start date reference. Below is the formula that will do this: =DATEDIF (B2,C2,"y")&" Years "&DATEDIF (B2,C2,"ym")&". อาการแปลกๆ ของ DATEDIF. Below is the formula that will do this: =DATEDIF (B2,C2,"y")&" Years "&DATEDIF (B2,C2,"ym")&" Months". Having trouble with the =DATEDIF function in Excel 2016. It's in the format of =Date("y","m","d"). Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏 Choose where you want to search below Search Search the Communitymrdelurk 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. "md" gets the days between dates, ignoring months and years. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. –Lastly, we can use the AVERAGE function to determine the average tenure within the data set. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands. Just enter =D1 - C1-----PS. 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. DATEDIF function (microsoft. So today is 43529 and midday today is 43529. With your system set up you should see the results you were expecting from:Now, you have to find the number of days between the two dates. . The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has a. The first part of your formula is the DATEDIF function: =DATEDIF (B5,TODAY (),"Y") And the second part of your formula, you are concatenating a space at the end of your result: & " ". If you read the DATEDIF tutorial carefully, you’ll see that Excel doesn’t show you the arguments you need to input as you type the formula, so this could be an easy mistake. For the remaining full months, I simply used: = (YEAR (E2)-YEAR (F2))*12+MONTH (E2)-MONTH (F2) For the days, DATEDIF doesn't like billed through dates higher than end dates and returns #NUM. In a new cell, write a formula like this: =C2-B2. Insert and format the current date and time. Type =DATEDIF (. 11. The first part of the formula is an exact copy of the formula used to return complete months i. 1 person found this reply helpful. There’s plenty of concern about Microsoft Excel’s DateDif function but there’s also a hidden trap that rarely gets a mention and is too easy to overlook. To use the DATEDIF Function to calculate the number of days between dates set the unit of measurement to “d” for days:. I am currently using the latest build of Excel as part of my Office 365 subscription. Hàm DATEDIF có thể tính toán các kết quả không đúng trong một số kịch bản nhất định. The number of years between two dates, start_date and end_date is calculated as follows: =YEARFRAC ( start_date, end_date ) Answer. I found a solution =((DAYS(TODAY(),E2))/365. Sometimes it will calculate the exact number of days but sometimes it will be short by one day. A good example would be calculating the age. Excel ISBLANK function. . Regards, Amit Tandon. For example, if you start a project on 01 Jan and it ends on 31 Jan, the DATEDIF function. Add one to the end date (second) parameter. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. In column F, we can use the following variations of the DATEDIF function to calculate the difference in years, months and days respectively. Microsoft no longer supports this function in Excel. Whenever I type a function into Microsoft Excel 2013, a small hint box is displayed which lists the function's arguments. The result will be displayed in the selected cell. I can not find and perform the function. The DATEDIF function returns the number of years, months or days between two dates and is officially "unsupported". But I'm not sure about Office 365. Likewise, =EDATE (DATE (2020,4,30), -4) returns the date 12/30/2019. Use the DATEDIF function when you want to calculate the difference between two dates. sobressair DATEDIF função. There is no DATEIF function, I suspect that you want DATEDIF. Write down the formula as: “=DATEDIF (A2,B2,"y")”. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date. In cell E2 we put our formula; =DATEDIF (B2,C2,”Y”) We then press Enter to get the time difference for that row. Calculate the difference between two dates. Note: DATEDIF function will exclude the start date when counting the month numbers. If you open the file attached it shall be shown in Italian locale. You can simply type =DATEDIF ( in a cell to use it. Answer HansV MVP MVP Replied on January 20, 2016 Report abuse There is no DATEIF function, I suspect that you want DATEDIF. R. – Mary La Point. Lastly, we will press the Enter key to return the result. Contoh Rumus DATEDIF Excel. I suspect that there are quite a few. Using the DatedIf function I am. DATEDIF function (microsoft. DATEDIF (C3,D3,"M"), the result being 3 months. Now, in the third argument, you need to enter the unit “y” to get the count of years. My question is: Why is the formula not working correctly without the "+1" part. We have to enter this argument in between two double inverted commas ex: “Unit”. It should be there, it just doesn't appear in the function list, as it was deprecated long ago. Microsoft Teams for Education. Replied on April 28, 2022. Subscribe to RSS Feed; Mark Discussion as New; Mark Discussion as Read; Pin this Discussion for Current User;. DATEDIF function helps to calculate the total number of days, months, Years between two date. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. This formula works. N. 1 Answer. This thread is locked. Dim date1 As Date Dim date2 As Date date1 = "14/10/2015 19:00:00" date2 = "14/10/2015 16:28:43" If DateDiff ("h", date1, date2) < 24 Then count = count + 1 End If. In addition, what will be the rule of thumb for calculating item no. Replied on April 28, 2022. As you can see from the info below, someone's actual age is calculated to show in years and months, as is the reading age - both using Datedif. e. MVP. Sure, you can enter the end date to calculate age, not for the current date. How to use The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. If the earlier date is in A1 and the later date in B1 you can just use: =B1-A1 and format the cell as a number, in stead of =DATEDIF(A1. 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 the difference between two dates in Excel. 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. Thanks for your help! The isnumber gives TRUE. The DATEDIF Function. Silakan lihat bagian masalah umum di artikel ini untuk detail selengkapnya. If you want a static value, use date and time shortcuts. Description. Fungsi DATEDIF mungkin menghitung hasil yang tidak benar di bawah skenario tertentu. I was using the datedif formula to calculate the days into a positive or negative number and it works great. Enter the start date and end date in their respective cells. You pass 0 and D2 ( C2 - B2 ). I now need to change it to calculate the datedif from the date which is a result of a workday. Use this function to select one of. Calculate age in years. DATEDIF ไว้ใช้ทำอะไร? DATEDIF เป็นฟังก์ชั่นเกี่ยวกับวันที่ ใช้หาว่าวันสองวันที่กำหนด ห่างกันกี่วัน กี่เดือน หรือ กี่ปี (เราเลือกได้) วิธีการใช้ฟังก. I found a solution :) =((DAYS(TODAY(),E2))/365. Replied on January 4, 2017. Vui lòng xem mục sự cố đã biết của bài. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. Forum Expert Join Date 07-11-2013 Location Phoenixville, PA MS-Off Ver MS Office 2016 Posts 4,465Make sure dates are not stored as text. There are three simple ways how to subtract dates in Excel, they are: Simple subtraction. I. Use the DATEDIF function when you want to calculate the difference between two dates. Step 3: Press Enter to get the result, which will be the difference in months between the two dates. 1 person found this. Software is Excel Online for Office 365. Regards, Rory. DATEDIF and February date. Esc to stopHere's a list of steps on how to subtract two dates in Excel to find the difference in months: Type your start and end dates into separate cells. 5 for example. The ISBLANK function in Excel checks whether a cell is blank or not. Using the NETWORKDAYS () function. "YM" - The difference in months between <start date> and <end date> ignoring years. The start_date and end_date arguments are required while the unit argument is optional. =DATEDIF (C10,CURRENT_DATE,"Y")&" Years,"&DATEDIF (C10,CURRENT_DATE,"YM")&" Months,"&DATEDIF (C10,CURRENT_DATE,"MD")&". To use the DATEDIF function for calculating months, select the cell where you want to display the result, enter the formula =DATEDIF(start_date, end_date, "m"), and press Enter. DATEDIF is the easiest way to find out how many years are between two dates. By te way, DATEDIF is not needed for this kind of calculation. (I found it on this site). Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations. Trying to retrieve the number of months between the two dates below. Something went wrong. This function does not appear in the 'Insert Function' dialog box and is not recognised in the 'Function Arguments. In Column C, you can write out the following specific formula: =DATEDIF (A3,B3"Y"). Keep the formula result selected, and press Ctrl + 1 to display the Format Cells dialog, then under Number tab, click Date from. Hoặc có thể đặt 3 phép tính trong 1 ô. Select a formatted range. Jadi, untuk menggunakan formula ini, kalian perlu mengetikkan secara manual pada cell yang dimaksud atau pada formula bar yang tersedia. of days, ignoring years. Follow the below steps to Find Age using Simple Math: Step 1: Enter DOB or Start_date into the cell. D3-C3 gives us the answer in days i. Next, refer to cell B1 where you have the ending date. Na planilha do Excel, se você quiser calcular o número de anos, meses, dias ou semanas entre duas datas, o DATEDIF função no Excel pode ajudá-lo. #1. Let's say that cell A1 contains someone's birthdate, and cell B1 contains the current date. It's fallen off current Excel menus, but you can still use it. This time around, we'll calculate the difference in terms of months. I suspect that DATEDIF is not available in the Italian version of Excel. ) and some manually calculated results. If the difference is 2 days or greater I would like it to show "Yes". By DaveBre in forum Excel Formulas & Functions. Deals for students and parents. The XLOOKUP looks for each month, or the next largest item (indicated by the final parameter), in the first array, then returns the corresponding position from the second array. I'm trying to calculate the difference between two dates in Excel. “M”: With this unit, DATEDIF function will return number of complete. Rajen66. These are the first and second arguments in our function. = (B1-B2)/365. A mixed formula is a formula that relies on both array calculation and implicit intersection, this was not supported by pre-dynamic array. You can simply type =DATEDIF ( in a cell to use it. e. While typing this function in a cell in Excel, it would NOT show the IntelliSense. g. YEARFRAC is another option. The DATEDIF function does exactly what the name suggests. Take a few minutes to practice with the TODAY function. Since lowest possible date in excel is 01-Jan-1900 and it is = 1, your arguments are 0 = 0-Jan-1900 (non existing date) and 546 = 29-Jun-1900. NOTE: If you want to calculate the age at a specific date, replace the TODAY () function with. Using the DatedIf function I am attempting to formulate the following: =datedif (mfg_date,expir_date,"m")- this is per every forum I've found. Anyways, let’s see how this formula work. Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. What is the syntax for Excel Datedif? The syntax for Excel Datedif is DATEDIF(start_date, end_date, unit). Follow the steps to calculate the age using. . We will not be able to use this method for our DateDif Function, as it is not recognised, so we will have to type it manually. Viewed 131 times 0 I'm trying to make a calculator that calculates the amount of years, months and days from one date to another. The VBA conversion function CDate can apply a little of the overhead you constantly pay for to correct the dates. Finally, move the cursor down to the last data cell to get results according to the formula. =DATEDIF (start,end,unit) Here's the info page at MS for a reference of the units. Important note – Unlike the other functions, the function will not appear as you start to type this date function. แนวทางการปรับสูตร DATEDIF ให้ทำงานดั่ง. . A suggestion is: UDF replacement for Excel's DATEDIF. You can find its syntax and usage here. You can vote as helpful, but you cannot reply or subscribe to this thread. Calculate the difference between 2 dates is not an easy task in Excel. Hence it must be typed manually in the formula box. Re: DATEDIF not working. #3. We want to know how old David is today. In the Date & Time Helper dialog box, do the following operations:. Re: Datedif_leap year. Select Z1 press Control-C (copy) 4. My formula is thus DatedIF (earlier date/beginning of the amortization period, the month end date,"m") + 1. Try entering =DATEDIF (A2,B2,"y") in another cell. In the first method, we will be using the IF function and the basic subtraction formula. Thus simply type. No DATEDIF () Function in the list. F6=DATEDIF (D6,E6,”m. The resulting value will be the number of whole days between the two dates. . Using the DatedIf function I am. 08 wont to fix the. Combine All Three Formulas to Get the Actual Age. XLOOKUP function (microsoft. Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. From this unit, we can identify the difference in months between a start date and an end date, irrespective of the days and years. =DATEDIF (B2,C2,"y")&" Years, "&DATEDIF (B2,C2,"ym")&" Months". HansV MVP. HOW TO ATTACH YOUR SAMPLE WORKBOOK: Unregistered, Fast answers need clear examples. The problem is that the calculation of days not always is accurate, or at least I don't think. In this formula, replace C2 with the cell where you have your end date, and replace B2 with the cell where you have your start date. png In B6 I have used the formula =DATEDIF(B3,B4,"d") In B7 I have used the formula =SUM(B6*C2) At the moment, what you see in the screenshot is how it should function. What I tried to do is this: =COUNTIF (DATEDIF (MyTable [CreatedDate], MyTable [ClosedDate], "d"), "> 40") That formula doesn't work, I believe for a couple of reasons: You can't pass ranges to DATEDIF, also DATEDIF returns a discrete value but COUNTIF expects a range. DATEDIF will not give any functional tip or hint and neither it will come as part of Insert Function. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. . It is important to know that this function is undocumented in Excel, such as EVALUATE, FILES, and GET. First, enter the DATEDIF function in cell C1. Fill in "d" for the third argument to get the number of days between two dates. Im Getting a #NUM! return when DATEDIF(B4,F10,"d") counts down normally then Hits -1. 2 Answers. For reference, you could view this page: DATEDIF function A difference in complete months, Ignoring days and years. In Excel, we can calculate a person’s age if we know the person’s date of birth and the current date. You can still use it. Creating a holiday calendar in Excel. Jun 17 2019 01:30 AM To get the SORT, FILTER and UNIQUE functions you must be on Insider FAST and on top of that you must be among the people who have. Step 3: Write the formula = (TODAY ()-A2)/365. Jan 30, 2016 at 2:05 @RonRosenfeld: Interesting. DATEDIF was introduced in Excel to ensure compatibility with Lotus 1-2-3, but it has never really been accepted as a standard Excel function. Type ,TODAY (),”Y”) & ” Years and ” & DATEDIF (. This is the easiest way to make a DATEDIF formula in Excel is to input two valid dates in separate cells and refer. I have the. I have noticed that a number of functions that I would like to use within formulas are not available. MSFT has been trying to deprecate the use of DATEDIF for many years. 4. R. May 25 2021 07:25 AM. Dùng hàm datedif để tìm ngày. For instance, these dates may be in Column A and Column B. end_date : Second date in a valid excel format. The result is 2. you can use Custom format (dd. If the earlier date is in A1 and the later date in B1 you can just use: =B1-A1 and format the cell as a number, in stead of =DATEDIF (A1,B1,"d") 0 Likes. If you must make such cells blank: copy the B column, and. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands. The Datedif function is used to calculate interval between two dates in days, months or years. You can use the following formula to calculate the person’s age: = DATEDIF (A1, A2, "Y") This will give you the person’s age in years. For example, =DATEDIF (Date1,Date2,"md") returns 28 for Date1 = 1-Feb-2007 and Date2 = 1-March-2009. First, "with great details comes great answers". There are a few other Formulas that are not shown in Excel. The steps to calculate DATEDIF in excel are as follows: Step 1: Select an empty cell to display the output. Dates and times are stored together (dates are day counts, stored as the integer portion of the value; times are fraction of a day, stored with the day count as a decimal fraction). Here's another screen shot that shows the formula works. e. This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). 3: FORMULATEXT (reference) Returns a formula as a text string. If you are not familiar with the scientific notation, I'll briefly explain what it means on an example of the smallest allowed positive number 2. HOW TO ATTACH YOUR SAMPLE WORKBOOK: Unregistered, Fast answers need clear examples. All you need to know is how you use the DATEDIF function to do your task. Can't find any reference to the DATEDIF () function. Aug 28, 2021. It creates it using the year in cell E17, and the month in cell E17. Our videos are about below Microsoft Reporting Tools:Excel Basic. For instance, you can use YEARFRAC to identify the proportion of a whole year's benefits, or. = (DateDiff ("d", [datesubmitted], [datecompleted])) I only want this to calculate the actual difference between weekdays, I am not concerned with working days ie public holidays. Step 2: Next, start by entering DATEDIF in excel formula. Calculating Age in Excel With the DATEDIF function. Discussion Options. Note: =A2-A1 produces the exact same result!I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Still, we can use the DATEDIF function to calculate the number of months between the two dates. Check Difference option from the Type section;; In the Arguments input textboxes, select the cells which. Apply DATEDIF & TODAY Functions to Count Age in Excel. It should work: Maybe, but you use 2020-12-31 as start date, not 2021-01-01 and for leap years the scaling must be dynamic to get the same 52. Save to an htm file on your hard drive (any file name). There are two options to enter the TODAY function into an Excel worksheet: Type the complete function into a worksheet cell. 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 should get the correct answer for =A3-A2 (ie. datedif excel 2010 I can not find "datedif" under excel 2010 . 57650273. 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. Flexible Payments. “d” gets the days between dates. 0. The above is as suggested by Sergei. We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. 1: DAYS (start_date, end_date) This will determine the number of days between the indicated two dates. For example, given a start date of 1-Jan-2018 and end date of 1-Jul-2018, the result should be a string like this: "1 years, 6 months, 0 days" DATEDIF. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. If it is 1 day or less I would like it to show "No". I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. In addition, there is no tooltip for DATEDIF (). To find out how many weeks there are between two dates, you can use the DATEDIF function with "D" unit to return the difference in days, and then divide the result by 7. Your formula might not return expected results if the cell’s data type can’t be used in calculations. )Here is a list of all Recalculate keyboard shortcuts: Shortcut. Not how B2 is not empty but contains a formula. Click in the Date 2 box and select a cell with the second date. Mode is a bit different – it has to be one of six in-built text codes (that is, entered with. Enter an equal sign and type the DATEDIF. 6-Step Guide for Calculating Date Duration: Open a new Excel document and create a table with two columns, “ Start Date ” and “ End Date “. INTL (A3,B3,1))) by giving it a name (very similar to naming a range or a cell) and then using. First, confirm that =ISNUMBER(--C3) returns TRUE. you can use Custom format (dd. 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 simplest way to calculate age in Excel is to use the Excel Yearfrac Function , which returns the number of years between two dates. But I wonder why you want to use that function at all. Functions to help deal with formula parse errors in Google Sheets. You can vote as helpful, but you cannot reply or subscribe to this thread. Sintaxe: A sintaxe para o DATEDIF função no Excel é: =DATEDIF(Start_Date, End_Date, Unit) Argumentos:Your first three examples return errors because your system is not interpreting 13/4/2013, 20/4/2013 and 29/4/2013 as dates, as are required for DATEDIF. Excel DATEDIF not showing the correct answer. e. The answer to your question can be found in this article: Excel DATEDIF function to get difference between two dates and How to calculate age in Excel: from date of birth, between two dates. XLOOKUP function (microsoft. . Educator training and development. khalkhall. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏. To fix this, change the cell’s data type from Text to General like this:1 Answer. 4. e. Basis - use basis 1 that tells Excel to divide the actual number of days per month by the actual number of days per year. Solved: I am tyring to add the column as follows = Table. Q2. However, there is an easy workaround. First put a start date in a cell, and an end date in another. Here's how it does this: First the DATE function creates the date, 5/1/2016. In the end, hit enter to get the result. Suppose the person’s date of birth is in cell A1 and the current date is in cell A2. Below I again have the same data set and I want to calculate the duration of service of each employee in years and months. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. •Beware of Scammers posting fake Support Numbers here. Meanwhile, I've figured out what was wrong with the whole thing - everywhere on the internet i saw that you should type =DATEDIF (c3 , d3, "d") but instead you should write ";"). 2. That brings us to the end of a simple, but extremely useful Excel function. You use the start date as the end date and vice versa while applying the formula. I have found the Ablebits app and. 2. Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. So, it looks like Excel changes a year for <start date> to the same as. F2 format General. Jon Wittwer September 1, 2017 14 comments. For some reason, this hint box doesn't appear when using DATEDIF (). Firstly, we will create a new column to input the results. Any idea why if the dates are only a. ***Support Technology for Teachers an. Can't find any reference to the DATEDIF () function. Technically, the NOW function returns the current date and time, but you can format as time only, as seen below: TODAY () // returns current date NOW () // returns current time. e. In this method, we will learn how to calculate the number of weeks between two dates using the DATEDIF function. Therefore, dates entered in this format are not recognized as dates and result in erroneous calculations. As you can see from the info below, someone's actual age is calculated to show in years and months, as is the reading age -. DATEDIF function (microsoft. Type "=DATEDIF" into another cell. Hence it must be typed manually in the formula box. . Answer. Click a cell where you want to locate the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:. Compute Age as Years, Months, and Days. If the cell is not blank, on the Edit menu, point to Clear, and then click All. Excel DATEDIF not showing the correct answer. . Step 4: Enter the end date as B2 in cell C2. I don't know how I oversaw this error, and less do I know why the internet says. Nov 27, 2022 at 16:22. 11). Now it’s time to combine all these to create an accurate age. The functions that I am currently attempting to use are DATEDIF, SORT, UNIQUE and FILTER. You can do it by following the steps below. Microsoft. g. You can find information at Chip Pearson's web site for the DateDif Function – Ron Rosenfeld. 25 gives you the result as shown below. 17 but you should type date like above. I have used the following formula: =IF(DATEDIF(C5,D5,"d")>=2,"Yes"<=2,"No")To find the number of years between two dates. DATEDIF is part of Excel primarily to provide support to old Lotus 1-2-3 workbooks, and will give inaccurate results under certain circumstances, as you have found. This formula will calculate the current age in full years – for example “32”. In the Save As dialog, select ‘Publish Sheet’ and ‘Add Interactivity’. It is important to note that the DATEDIF function may not work correctly if the start date is after the end date. If you want to use Current date then use this formula in cell T2: =DATEDIF (R2,TODAY (),"Y")&" Years "&DATEDIF (R2,TODAY. Luckily, it is still there, but you have to know the arguments because Ex. Anyways, let’s see how this formula work. If you are not familiar with the scientific notation, I'll briefly explain what it means on an example of the smallest allowed positive number 2. First put a start date in a cell, and an end date in another. . The DATEDIF function may calculate incorrect results under certain. EXclude start date, INclude end date We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. 3.