Select a cell in the third column so that it is adjacent to the start and end dates, as shown below. 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. 6-Step Guide for Calculating Date Duration: Open a new Excel document and create a table with two columns, “ Start Date ” and “ End Date “. Rory Archibald. Calculate the difference between two dates. The Datedif function is used to calculate interval between two dates in days, months or years. In this Forum, we are Microsoft consumers just like yourself. 25 gives you the result as shown below. mm. Anyways, let’s see how this formula work. 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. EXclude start date. Missing functions in Excel. I searched Excel help and function reference, and MS knowledgebase. (2) Dynamic date difference between two cells, where one is static, and one has dynamic value TODAY (). If not, we might need more information. It does exist. To find an age, use this formula: =YEARFRAC (B2,TODAY (),1) Replace B2 with the cell containing the birth date. Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. I've tried both and I can't get either to work. It was probably included for compatibility with. 01. The first two arguments must be dates: references to cells containing dates, or expressions that evaluate to dates. Replacement Formula - MD Column "D" uses the DATEDIF function and often gives the incorrect answer. The mysterious datedif function in Microsoft Excel. You can vote as helpful, but you cannot reply or subscribe to this thread. e. In addition, there is no tooltip for DATEDIF (). In the first example the DATEDIF excel formula used is:. You will have to write complete syntax of DATEDIF. Using the DatedIf function I am. You need to know the arguments and how to use it. 5 for example. Whenever I type a function into Microsoft Excel 2013, a small hint box is displayed which lists the function's arguments. The syntax of the DATEDIF function is DATEDIF(start_date, end_date, unit). Also, February is only counted to be 28 days and not one month (see item no. 1 person found this. 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 requires first 2 arguments as a date. F5=DATEDIF (D5,E5,”y”) // returns 2. = (B1-B2)/365. Step 3: Enter the start date as A2 in cell C2. Below I again have the same data set and I want to calculate the duration of service of each employee in years and months. I now need to change it to calculate the datedif from the date which is a result of a workday. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. If the cell is not blank, on the Edit menu, point to Clear, and then click All. I suspect that there are quite a few. In this Forum, we are Microsoft consumers just like yourself. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands. So that's 57 years. 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. 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. It’s syntax is: =DATEDIF(start_date, end_date, unit) start_date – The start date in Excel serial number format. Hit Enter, and you. Using the DatedIf function I am. Microsoft Teams for Education. The resulting value will be the number of whole days between the two dates. . I entered the formula in B1 and use Format Painter to give it the same format as A1. In column F, we can use the following variations of the DATEDIF function to calculate the difference in years, months and days respectively. The DATEDIF function may calculate incorrect results under certain. You should get the correct answer for =A3-A2 (ie. After adding the formula, press the Enter button to see the result. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. 1. Luckily, it is still there, but you have to know the arguments because Ex. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏. To use the function, enter the dates into the appropriate cells, and then enter the desired calculation into the cell where you want the result. The steps to calculate DATEDIF in excel are as follows: Step 1: Select an empty cell to display the output. DATEDIF function helps to calculate the total number of days, months, Years between two date. Consider the below example where we have the current date and date of birth. Dates are stored as numbers, so whatever the outcome of your formula is, it will get displayed as the date that is as many days after 1 January 1900. DATEDIF is practically an insider tip, as the function is not even included in the internal list in the software. Sorted by: 0. Syntax: =DATEDIF (start_date, end_date, unit) Start_date : First date in a valid excel format. If the dates are more than 1 month apart it returns the correct result. The following formula will give you the total number of days between the two dates: =DAYS (B2,B1) Note that you can also manually specify the dates in the Days function by putting it in double-quotes. =DATEDIF (A1;B1;"M") does not work, returns "1900-01-03" but should return "3" (jan+feb+mar). B2 is the field containing the date of birth. Here's how it does this: First the DATE function creates the date, 5/1/2016. DATEDIF function is very useful in calculating any age in Excel. Subscribe to RSS Feed; Mark Discussion as New; Mark Discussion as Read; Pin this Discussion for Current User;. . DatedIf Not Working. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. To make a perfectly true age formula, supply the following values to the YEARFRAC function: Start_date - date of birth. •Beware of Scammers posting fake Support Numbers here. Click in the Date 1 box (or click the Collapse Dialog button to the right of the box) and select a cell containing the first date. Then type a formula like one of the following. Insert and format the current date and time. For example, to calculate the difference in years between two dates, enter the following. Re: I can't get the DatedIf function to work -- returns #value! In D2 and E2 you've text date not excel date. F9. For reasons unknown, it is only documented in Excel 2000, but you can use it in your formulas in all Excel versions since that time. However, some dates in your worksheet may be stored as text strings instead. B4 is populated via NOW() F10 is populated Via another cell with a manually entered date +7 as so D10+7. 25 gives you the result as shown below. It's not in the list. Use the DATEDIF function when you want to calculate the difference between two dates. Example: =IF(A5="","",(DATEDIF(A5,TODAY(),"d"))) It works fine, but if a future date is entered into A5, e. Flexible Payments. MSFT has been trying to deprecate the use of DATEDIF for many years. Click the cell containing the date of birth. 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: & " ". Hoặc có thể đặt 3 phép tính trong 1 ô. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Please remember that array formulas should be completed by pressing the Ctrl + Shift + Enter shortcut. F2 format General. . The DATEDIF calculates the months between the dates. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has a. This formula currently is working: DATEDIF(V2,TODAY(),"y") & " years " & DATEDIF(V2,TODAY(),"ym") & " months "I am looking for a formula that would like to not use "today", rather a specific date, for. 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. Thus simply type in cell =DATEDIF(. The VBA conversion function CDate can apply a little of the overhead you constantly pay for to correct the dates. The "Date" function would work for your purposes. 2251 is multiplied by 10 raised to the power of -308 (2. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. Here’s how you can calculate age when the DOB or start date is given: In the destination cell, enter the following formula: =INT ( (TODAY ()-B2)/365) In the above formula, B2 is the source data for DOB or start date. Vui lòng xem mục sự cố đã biết của bài. I've been typing =DATEDIF (D2, TODAY (),"Y") Excel seems to recognize the first cell as part of the function, but not the second value (i've tried other cells on the place of today () too. This function is available in all versions of Excel but is not documented. Likewise, =EDATE (DATE (2020,4,30), -4) returns the date 12/30/2019. If the difference is 2 days or greater I would like it to show "Yes". Functions to help deal with formula parse errors in Google Sheets. =DATEDIF (C10,CURRENT_DATE,"Y")&" Years,"&DATEDIF (C10,CURRENT_DATE,"YM")&" Months,"&DATEDIF (C10,CURRENT_DATE,"MD")&". Its syntax includes three arguments: start_date, end_date, and unit. Enter your birthdate in one cell of Excel and the DATEDIF formula into a different cell. F6=DATEDIF (D6,E6,”m. You must take in consideration if you want to return a result based on the gap of the months or based of the years, or both. It does not work properly in all cases and they are not going to fix it. Reply;. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands. Devices for education. = (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. But I'm not sure about Office 365. 25) and then reduced to 1 decimal which actually works great for me, maybe not for others. Unlike other functions, undocumented functions cannot be found in the function list and will not appear when you start typing the name of the function. อาการแปลกๆ อันอื่น. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date. Format for months is: =DATEDIF (A3,A2,"m") Also, a side note, the VB function DateDiff is also still valid, uses a lot of the same lettering, and is a little more robust. Then, for the second argument, we have to enter or select the number of days. Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations. Here's how it does this: First the DATE function creates the date, 5/1/2016. Forum Guru Join Date 12-31-2011 Location Pittsburgh MS-Off Ver 2002, 2007:2013 Posts 18,890 DATEDIF Function. Mode is a bit different – it has to be one of six in-built text codes (that is, entered with. 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. 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). if you format the cell as general that date should appear as 36892 so that indicates the date is text and not a real date number, its the original that needs changing once its changed to a real date it should work on any machine, datedif works with text dates as long as they are in the correct format on my machine 23/4/08 would work as / is my. Web. 1666 week value. Answer. . 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. The code I'm using is: select datediff (day, '2014-01-01', '2014-02-01') I assume I'm missing something very simple (this is a hugely basic query I'm sure), but would be appreciative of any assistance. Replies: 9. Then, we have used DATEDIF again pretty much the same way to return the number of months but the code has been. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. see att. I use Excel 2013 and scandinavian dates and cannot get DATEDIF-function to work. Using the DatedIf function I am. First of all, you should avoid passing D2 directly to DATEDIF formula. =DATEDIF(A1,B1,"y") see here for more Calculate the difference between two dates. Note: Excel won't help you fill. . This is the optional part of the formula. > Hi > I checked the link but could see nothing about the fact that the function > does not appear in the list of functions under 'insert'. Sure, you can enter the end date to calculate age, not for the current date. The DATEDIF function has three arguments. XLOOKUP function (microsoft. Step 2: In a different cell, use the DATEDIF function to calculate the difference: =DATEDIF(A2, B2, "m") The syntax for DATEDIF is DATEDIF(start_date, end_date, unit). In A we have start date, in G end date, in C - when we had a meeting. Re: DATEDIF is returning a date when asking for amount of years. DATEDIF (C3,D3,"M"), the result being 3 months. It is available in most versions, but not well documented in some of them. Report abuse. It creates it using the year in cell E17, and the month in cell E17. NOTE: If you want to calculate the age at a specific date, replace the TODAY () function with. all cells are date formatted the same. INTL (A3,B3,1))) by giving it a name (very similar to naming a range or a cell) and then using that. 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. Thus simply type in cell =DATEDIF (. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. 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. Well, let me first commend you on a very complicated formula that works. Here's how it does this: First the DATE function creates the date, 5/1/2016. In this example, column D contains the date March 1, 2019 and column E contains the date April 5, 2021. counts down perfectly until -1 should be shown but instead returns #NUM!The first date is specified in cell B4 and the second date in cell C4. Let's say you have dates in A2 and B2. "md" gets the days between dates, ignoring months and years. If you want to use Current date then use this formula in cell T2: =DATEDIF (R2,TODAY (),"Y")&" Years "&DATEDIF (R2,TODAY. 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. Follow the steps to calculate the age using. Something went wrong. Type =DATEDIF (. First put a start date in a cell, and an end date in another. Een alternatieve manier om het verschil in dagen tussen twee datums te berekenen is om gewoon de ene datum van de andere af te trekken. " It’s operational in all Excel versions, but it’s not on the Formulas menu or in the Help menus after Excel 2000" yardımda ve fonksiyonlarda yok diyor, nerde o zaman ? @hotmail_hotmail sen söyleyince fark ettim walla : ÇözüldüBy bloo10 in forum Excel Formulas & Functions. Our videos are about below Microsoft Reporting Tools:Excel Basic. By te way, DATEDIF is not needed for this kind of calculation. simply subtract the smaller date from the later date. I have used the DATEDIF function to do this in the past, but it doesn't seem to be working correctly. For example, =DATEDIF (Date1,Date2,"md") returns 28 for Date1 = 1-Feb-2007 and Date2 = 1-March-2009. This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. 25) or =INT (YEARFRAC (start,end)) are not 100% correct. That being said, I'm not familiar with a simpler or more efficient alternative. 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. Go ahead and try the rest of the intervals. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). )Here is a list of all Recalculate keyboard shortcuts: Shortcut. Press Enter key then drag fill handle down to the cells for applying this formula. In otherwords, if the start date has 31 days, Apr/Jun/Sep/Nov all have issues if your start date is the 31st. Nov 27, 2022 at 16:22. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). YEARFRAC calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). You need to know the arguments and how to use it. To calculate an age: = DATEDIF (<start date>, TODAY (), "y") Note: The formula TODAY () returns the current date. 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. You can still use it. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏 Choose where you want to search below Search Search the Community 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. Feb 02 2023 04:00 AM. The problem is not with your version of Excel; the DATEDIF function is an undocumented function. Yes, you can use the DATEDIF function to calculate a person’s age. Type "=DATEDIF" into another cell. Type the cell that contains the start date and add a comma. See attached example. This thread is locked. Select cell D4. Converting date differences into months and years has always been. Show dates as days of the week. However, DATEDIF works in all modern versions of Excel and is a useful function for calculating the. The function takes the arguments of start date, end date and the option for the output type. The syntax is: =DATEDIF (start date, end date, mode) Start date and end date are simple and self-explanatory enough – they are the cells or date values that mark the beginning and end of the period we are examining. 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. Please find the screenshot below. Here's what I could get to work: IF (DATEDIF (DATE-1,DATE-2,"COUNTS DAYS BETWEEN DATES SELECTED")="DAYS IN A WEEK","VALUE IF. 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. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. The DATEDIF Function Returns the number of days, months or years between two dates. Basis - use basis 1 that tells Excel to divide the actual number of days per month by the actual number of days per year. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. There are three simple ways how to subtract dates in Excel, they are: Simple subtraction. You can delete Z1. Using the DatedIf function I am. 25. It should be there, it just doesn't appear in the function list, as it was deprecated long ago. e. . 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. I. MD Days function returns wrong value. 3 is correct though in the context of what DATEDIF provides, since there's 3 hours (and not 4) between 12:09PM and 3:59PM. While typing this function in a cell in Excel, it would NOT show the IntelliSense. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. 2 people found this reply helpful. The "E-308" part of the notation means "times 10. 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. While typing this function in a cell in Excel, it would NOT show the IntelliSense. Now it’s time to combine all these to create an accurate age. Just enter =D1 - C1-----PS. . I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Step 4: Enter the end date as B2 in cell C2. See screenshot below. but it doesn't appear in the function list or in the help files! Try just typing the formula in , 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). =DATEDIF(A2, A5, "y") - returns the number of complete years between the dates in A2 and B2. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. DATEDIF is just designed to return whole numbers. Use this function to select one of. The <>”” means if a cell isn’t blank and =“” means the cell is blank based on what I found online. 2. And then, the SUM function adds up the values in the resulting array {50; 40; 0} and outputs the final result (50+40=90). This is a great function if you work. There is no DATEIF function, I suspect that you want DATEDIF. DATEDIF calculates the number of years, months, and days between the two dates, yielding your age. DATEDIF function: Calculates the number of days, months, or years between two dates. I have the. Education. Select a formatted range. 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. 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. To fix Excel Datedif not working, check the syntax of the function and make sure the dates are in the correct format. Description. I am trying to use DATEDIF function in excel, which is an updated version on office 365, but it seems that the function does not exist. Since 12/31/2019 is after that, it makes sense for DATEDIF to return less than 2, namely 1. It's in the format of =Date("y","m","d"). 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. Want all of our free Excel videos? Download our free iPad app at which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. Sorted by: 5. This function does not appear in the 'Insert Function' dialog box and is not recognised in the 'Function Arguments. Then the 1 represents the first day of that month. This function is available in all versions of Excel but is not documented. 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. This formula currently is working: DATEDIF(V2,TODAY(),"y") & " years " & DATEDIF(V2,TODAY(),"ym") & " months "I am looking for a formula that would like to not use "today", rather a specific date, for. If you take a cell containing =TODAY () and format it as general or number then today (March 5, 2019) it will appear as 43529. Below are the formulas you can use to get the age in Years, Months, and Days: Years: =DATEDIF (B2, TODAY (), “Y”) Months: =DATEDIF (B2, TODAY (), “YM”) Days:. In your spreadsheet, click the cell in which you want to display the answer. Well, let me first commend you on a very complicated formula that works. Re-type 01/01/2017 and 01/01/2018 . DATEDIF is the easiest way to find out how many years are between two dates. g. I am using the DATEDIF() and TODAY functions, using Excel 2007, but there are too many days displayed. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. You can find its syntax and usage 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 ";"). EXclude start date, INclude end date We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. But I wonder why you want to use that function at all. However, you can manually type the DateDif formula into a cell and by following the instructions in this post, get the results described. HansV MVP. It’ll not even show the function’s name as you enter it in a cell. All three parts worked flawlessly with either the literal or the reference to the cell in the same row of column C (which contained the date). Hi! Probably a very basic question for you experts, but I have the following formula, calculating days elapsed in column B from a column of dates in col. There are two options to enter the TODAY function into an Excel worksheet: Type the complete function into a worksheet cell. The above formula contains two DATEDIF functions. To test this out, select the cell and set its format to General. 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". 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. Calculate the difference between two dates. No DATEDIF () Function in the list. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. com DATEDIF in Excel Online for Office 365? With DATEDIF () it's possible to calculate a date difference for two dates. The Datedif function is used to calculate interval between two dates in days, months or years. I can not find and perform the function. INTL(A3,B3,1))) by giving it a name (very similar to naming a range or. Now it’s time to combine all these to create an accurate age. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). Calculate age in years. Use the DATEDIF function when you want to calculate the difference between two dates. If you are t…Use the DATEDIF function when you want to calculate the difference between two dates. . Keep the formula result selected, and press Ctrl + 1 to display the Format Cells dialog, then under Number tab, click Date from. Select Date 1 range 5. intl formula and I can't figure it out. Viewed 131 times 0 I'm trying to. Education consultation appointment. This time around, we'll calculate the difference in terms of months. Attention - ExcelForum Rules have been updated as of August 2023. For a long time, official documentation on DATEDIF was sparse. Just subtract two dates. Now, in the third argument, you need to enter the unit “y” to get the count of years. You can vote as helpful, but you cannot reply or subscribe to this thread. Re: DatedIf Not Working @cdersarkisian I’m on my iPad and it reads the formula fine however I think it’s the “y” that is not working or any of its variants however I have no grounds backing that theory whatsoever so I really need someone’s help please, I really need this function to work for me lolRe: DatedIf Not Working @cdersarkisian I’m on my iPad and it reads the formula fine however I think it’s the “y” that is not working or any of its variants however I have no grounds backing that theory whatsoever so I really need someone’s help please, I really need this function to work for me lolWe would like to show you a description here but the site won’t allow us. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. Deals for students and parents. Thus if you do G5-E4, as 05-Mar-2019 - 06. Type the cell that contains the start date and add a comma. I'm trying to do this: =VLOOKUP((DATEDIF(A2,C2,"Y"),H1:I10,2)) It doesn't work, I have found. Last Post: 05-27-2018, 10:51 PM. 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. Search for the Function you want to use, and select go. 📌 Steps: Click on cell D5 and then type the following formula. 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. Excel has an incredible function to realize all the different calculation between 2 dates. Steps: Firstly, choose the D5 cell and write the following formula down, =DATEDIF (B5,C5,"ym") Then, press the Enter button. After that, refer to cell A1, where you have the start date. คือว่าผมจะคำนวนหาอายุในExcel แต่ไม่มีฟังชั่น datedif จะใช้ฟังชั่นไหนได้บ้าง. N. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered.