I am trying to calculate the difference between two dates, with the answer displayed in months, and was referred to the =DATEDIF formula by a friend as shown below: But when I enter that formula for my data, the second cell keeps turning red and when I finish the formula and press. Ask Question Asked 3 years, 1 month ago. Select File * Save as Web Page. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Enter an equal sign and type the DATEDIF. 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. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. So if you want to find out how many days, years or months have passed since you were born, well this is the formula for you! Well you can also extend this to project start and end dates, but you get my point. This video is going to show you how to use Datedif function in Microsoft Excel 2007 and calculate the difference of Years, Months and dates between two dates. 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. You need to know the arguments and how to use it. EXclude start date, INclude end date We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. HansV MVP. 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. 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. First, enter the DATEDIF function in cell C1. Only Feb has issues if your start date is the 30th. We have to enter this argument in between two double inverted commas ex: “Unit”. 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 ";"). May 01 2022 08:23 AM. Example 1: Common Uses. First put a start date in a cell, and an end date in another. The start_date and end_date arguments are required while the unit argument is optional. 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. Follow the steps to calculate the age using. 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. This video is going to show you how to use Datedif function in Microsoft Excel 2007 and calculate the difference of Years, Months and dates between two dates. Add one to the end date (second) parameter. The resulting value will be the number of whole days between the two dates. Insert and format the current date and time. @towshin sharier . Warning: If the Start_date is greater than the End_date, the result will be #NUM!. The Excel DATEDIF function returns the difference between two date values in years, months, or days. My question is: Why is the formula not working correctly without the "+1" part. 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). You can do it by following the steps below. You can still use it, but you don’t get any help with it. Ask Question Asked 3 years, 1 month ago. Show dates as days of the. INclude start and end date. Let's say that cell A1 contains someone's birthdate, and cell B1 contains the current date. It is the DATEDIF function. . Oct 21, 2021. The DATEDIF function may calculate incorrect results under certain scenarios. Select Date 1 range 5. Silakan lihat bagian masalah umum di artikel ini untuk detail selengkapnya. Feb 02 2023 04:00 AM. Use this function to select one of. 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". Replied on January 20, 2016. Then type a formula like one of the following. Warning: If the. Type =DATEDIF (. if C1 is blank and time interval between two dates (G2 and today) is more or equals F2-2, then ''Attention". I found a solution :) =((DAYS(TODAY(),E2))/365. When calculating date intervals, DATEDIF uses the year of Date1, not Date2 when calculating the yd, ym and md intervals. But as long as you know that it's there and you know how it works. 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. DatedIf Not Working. Attention - ExcelForum Rules have been updated as of August 2023. In the example shown, the formula in E5 is: =DATEDIF(B5,C5,"y")&" years,. simply subtract the smaller date from the later date. Then, we will type in the formula “=DATEDIF (C2, TODAY (), “M”)”. อาการแปลกๆ ของ DATEDIF. 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. In this Forum, we are Microsoft consumers just like yourself. Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. After that, refer to cell A1, where you have the start date. The "E-308" part of the notation means "times 10. Using the DatedIf function I am. I am using the DATEDIF() and TODAY functions, using Excel 2007, but there are too many days displayed. This particular formula will return the number of years and months between the start date in cell A2 and the end date in cell B2. Thus simply type in cell =DATEDIF(. Next, in cell A4 type your formula DATEDIF (A1,A2,”Y”). I tried to use the DATEDIF function to find the number of month between to dates i. 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. After installing Kutools for Excel, please do as this:. Now it’s time to combine all these to create an accurate age. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. Not how B2 is not empty but contains a formula. Excel has had a DATEDIF function for many years. Using the DatedIf function I am. Microsoft no longer supports this function in Excel. Click the cell containing the date of birth. Yes, you can use the DATEDIF function to calculate a person’s age. . To fix Excel Datedif not working, check the syntax of the function and make sure the dates are in the correct format. The DATEDIF function has three arguments. . Mode is a bit different – it has to be one of six in-built text codes (that is, entered with. . 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. The DATEDIF Function typically calculates the number of days between two dates. If the difference is 2 days or greater I would like it to show "Yes". 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. Depending on what you need it for, and how dynamic you want it to be, you can use references to another cell that contains the original date, and references to cells that contain the changes to be made. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. Step 2: Next, start by entering DATEDIF in excel formula. However, you can manually type the DateDif formula into a cell and by following the instructions in this post, get the results described. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. Functions to help deal with formula parse errors in Google Sheets. DATEDIF is just designed to return whole numbers. To count the months between the dates in cell B3 and C3, please use the formula as this: =YEARFRAC (C3,B3)*12. Since 12/31/2019 is after that, it makes sense for DATEDIF to return less than 2, namely 1. You can find its syntax and usage here. Solved: I am tyring to add the column as follows = Table. Education. The simplest way to calculate age in Excel is to use the Excel Yearfrac Function , which returns the number of years between two dates. DatedIf Not Working. Regards, Rory. . Excel; DatedIf Not Working; DatedIf Not Working. 17 but you should type date like above. . Replied on April 28, 2022. Syntax: The syntax for the DATEDIF function in Excel is: =DATEDIF(Start_Date, End_Date, Unit) Arguments:จะคำนวนหาอายุใน Excel ใช้ฟังชั่นอะไรอะครับ ?? Microsoft Excel Microsoft Office. Note: these are volatile functions and will recalculate with every worksheet change. You shall type it on your own, Excel shows nothing while you are entering function. You use the start date as the end date and vice versa while applying the formula. So, it looks like Excel changes a year for <start date> to the same as. 25) or =INT (YEARFRAC (start,end)) are not 100% correct. com DATEDIF in Excel Online for Office 365? With DATEDIF () it's possible to calculate a date difference for two dates. Note: Excel won't help you fill. 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. You pass 0 and D2 ( C2 - B2 ). SyntaxThe mysterious datedif function in Microsoft Excel. – Ron Rosenfeld. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. Type "=DATEDIF" into another cell. 2251E-308. I have used the following formula: =IF(DATEDIF(C5,D5,"d")>=2,"Yes"<=2,"No")To find the number of years between two dates. 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. . This is a great function if you work. If you author or edit a formula in dynamic array Excel that contains the @ operator, it may appear as _xlfn. The function takes the arguments of start date, end date and the option for the output type. There are a few other Formulas that are not shown in Excel. You can vote as helpful, but you cannot reply or subscribe to this thread. Firstly, we have DATEDIF for returning the number of years between the two dates, and then the & operator joins the text "Y" to DATEDIF's result. Hi Rex, so sorry I haven't got back to you sooner I've just been incredibly busy. . Just enter =D1 - C1-----PS. 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). One little known way is to use the secret Excel DATEDIF function. UNIQUE () and XLOOKUP () only available to. What are the units for Excel Datedif?Greetings! I've been searching these forums for quite some time now and have tried many different formulas and conditions yet I have made no progress and am now requesting some help! What I'm trying to accomplish: -Column C (excluding cell C1) will contain dates that a user will input based on the date they store an item. In theory, that should "fix" it, and you should see the result of the formula. =DATEDIF (B2,C2,"y")&" Years, "&DATEDIF (B2,C2,"ym")&" Months". - this is per every forum I've found. Select Z1 press Control-C (copy) 4. 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. --HTH RP (remove nothere from the email address if mailing direct) "UOF" <[email protected]> wrote in message news:[email protected]. I hope it’ll be helpful. However, if an additional option Y is provided, like in this example, DATEDIF returns the number of years. e. khalkhall. Using the DatedIf function I am. Im Getting a #NUM! return when DATEDIF(B4,F10,"d") counts down normally then Hits -1. for example:We would like to show you a description here but the site won’t allow us. Here we can use the simple logical formula to find the Age by using the formula below. Press Enter to see your current age. But I wonder why you want to use that function at all. Check Difference option from the Type section;; In the Arguments input textboxes, select the cells which. #agecalculationwithoutdatedif #datedif Topic Covered:- what if my excel doesn't have datedif in my excelmere excel me dated if nahi ho to kya karewhat if dat. Dates are generated through functions beneath. here is my sample. After some experimentation, I noted that the DateDif function uses the month-end date of the start month to decide if a month has passed. Description. The result of the calculation was 17. Discussion Options. 3. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. This can be done in multiple ways as follows: Cell References. It’ll not even show the. Excel sees you are calculating with dates and thinks you want to display the result as a date as well. . DATEDIF function is not found in the standard function library of Excel because of some erroneous results it might show in certain circumstances which will be discussed later in the article. Subscribe to RSS Feed; Mark Discussion as New; Mark Discussion as Read; Pin this Discussion for Current User;. Step 1: In this example, we will use the following data to find the no. HansV MVP. For example, if cell A2. intl formula and I can't figure it out. –Lastly, we can use the AVERAGE function to determine the average tenure within the data set. 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. Excel has an incredible function to realize all the different calculation between 2 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. Fraction between same dates, using the Actual/Actual basis argument. 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. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. Here's another screen shot that shows the formula works. It's not in the list. The simplest and most accurate formula to calculate age in Excel is =DATEDIF (birth_date,as_of_date,"y"). Using the DatedIf function I am. F5=DATEDIF (D5,E5,”y”) // returns 2. From this unit, we can identify the difference in months between a start date and an end date, irrespective of the days and years. Using the DAYS () function. Press enter. MVP. First, confirm that =ISNUMBER(--C3) returns TRUE. Excel returns 582 in cell D4 meaning there are 582 days between "11/20/2010" and "6/24/2012". “y” gets the Years between dates. Bijvoorbeeld, =B1-A1 geeft je het aantal dagen tussen 23-03-2023 en 07-12-1998. I have tested it like this without any errors. Replies: 9. Its syntax includes three arguments: start_date, end_date, and unit. = (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. Reply;. I was comparing the dates in two columns to see if they were the same or different =IF (D2=N2,"same","different") and it was returning incorrect results. 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. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands. In the first example the DATEDIF excel formula used is:. e. The DATEDIF function does exactly what the name suggests. Select Special Paste, Multiplicate This must convert all text to number (dates). Because 2012 is a Leap year, it has a 366 day basis. Learn how to use this hidden function to quickly calculate the difference between two dates, in days, months, or years. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). Microsoft Teams for Education. = (B1-B2)/365. 4. I have the following formula in a report field. Put in a start date, put in an end date, and then put in one of these codes, like, “y”. I have the same question (0) Report abuse Report abuse. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. Re: I can't get the DatedIf function to work -- returns #value! In D2 and E2 you've text date not excel date. Is it possible to only count only the weekdays. You should get the correct answer for =A3-A2 (ie. For example, to calculate the difference in years between two dates, enter the following. DATEDIF Function – Number of Days Between Dates. The "MD" argument may result in a negative number, a zero, or an inaccurate result. Dates in Excel are actually sequential numbers starting from 1, which is belong to 01 Jan 1900 (on. 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. 5 for example. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. Likewise, =EDATE (DATE (2020,4,30), -4) returns the date 12/30/2019. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). B4 is populated via NOW() F10 is populated Via another cell with a manually entered date +7 as so D10+7. Replied on January 20, 2016. 2 people found this reply helpful. Then the 1 represents the first day of that month. 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. All you need to know is how you use the DATEDIF function to do your task. DATEDIF ensures that you're working with dates rather than date/times. Click in the Date 2 box and select a cell with the second date. 3. I have used the DATEDIF function to do this in the past, but it doesn't seem to be working correctly. I have the. The above is as suggested by Sergei Baklan in the thread below. We have selected cell C2 in this case. This time around, we'll calculate the difference in terms of months. Then, we have used DATEDIF again pretty much the same way to return the number of months but the code has been. F2 format General. So today is 43529 and midday today is 43529. S but I did try that- didn't work!The DATEDIF function stands for “ date difference ” and it calculates the number of Days, Months, or Years between two dates. Then type a formula like one of the following. So I'm wondering if one or both of those dates just appear to dates properly formatted, but are@geneseesquire . 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 shortdate seperator but 23. . Then, with the cell still selected -- do not click to edit the cell itself, instead -- put your cursor up into the formula bar (where you see the formula up there) and hit Enter up there. =DATEDIF(A2, A5, "y") - returns the number of complete years between the dates in A2 and B2. 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. It does exist. Please find the screenshot below. The DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates. . I've variously tried pointing it towards the specific table I want to draw from,. Formula DATEDIF tidak terdapat pada fitur auto complete pada Excel. 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. end_date : Second date in a valid excel format. The syntax of the DATEDIF function is DATEDIF (start_date,end_date,unit). Answer. F2 format General. If you open the file attached it shall be shown in Italian locale. In Excel, we can calculate a person’s age if we know the person’s date of birth and the current date. DATEDIF function helps to calculate the total number of days, months, Years between two date. Syntax: =DATEDIF (start_date, end_date, unit) Start_date : First date in a valid excel format. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. See the below given image. Fungsi DATEDIF mungkin menghitung hasil yang tidak benar di bawah skenario tertentu. F6=DATEDIF (D6,E6,”m. Compute Age as Years, Months, and Days. if you want to have the same result on Excel 2013/2010 you can use this workaround: = ( [end date]- [Start date])*24`. You have to have the whole syntax and the order of elements accurately in order to get an accurate result as well. This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). YEARFRAC is another option. The syntax of the DATEDIF function is DATEDIF(start_date, end_date, unit). e. Add one to the start date (first) parameter. Last Post: 08-27-2015, 06:22 PM. Modified 3 years, 1 month ago. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. The following is an example of a datedif formula in Microsoft Excel. . If you want a static value, use date and time shortcuts. If you are t…Use the DATEDIF function when you want to calculate the difference between two dates. Converting date differences into months and years has always been ambiguous. DATEDIF. 2251E-308. Our videos are about below Microsoft Reporting Tools:Excel Basic. 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. microsoft. 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. Luckily, it is still there, but you have to know the arguments because Ex. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. Harassment is any behavior intended to disturb or upset a person or group of people. . Save to an htm file on your hard drive (any file name). Instead you would need to use the corresponding serial number: 42320. However, it works in all versions of Excel. Now, we will show you how you can count their age using the DATEDIF and TODAY functions in Excel. For a new thread (1st. However, DATEDIF works in all modern versions of Excel and is a useful function for calculating the interval between two dates in years, months, and days. Since Date1 is not a leap year, the date 29-Feb is not counted. First put a start date in a cell, and an end date in another. Further to that: This occurs when you commit a mixed formula. (2) Dynamic date difference between two cells, where one is static, and one has dynamic value TODAY (). 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. 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. 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. . sobressair DATEDIF função. Sometimes it will calculate the exact number of days but sometimes it will be short by one day. number of days. ProgrammingError: ERROR: column "day" does not exist. Hi Rex, so sorry I haven't got back to you sooner I've just been incredibly busy. With the help of these methods, we are going to determine if those days are overdue or not in the first place and then calculate the overdue days in Excel. I suspect that there are quite a few. I have no idea why DATEDIF is not well documented but I'm not sure you can describe the above as a "bug" any more than the issues with floating point arithmetic. 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. N. R. Thanks for your help! The isnumber gives TRUE. In this example, column D contains the date March 1, 2019 and column E contains the date April 5, 2021. yy) to see 01. 1: DAYS (start_date, end_date) This will determine the number of days between the indicated two dates. YEARFRAC calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). For example, =DATEDIF (Date1,Date2,"md") returns 28 for Date1 = 1-Feb-2007 and Date2 = 1-March-2009. D3-C3 gives us the answer in days i. Now it’s time to combine all these to create an accurate age. This function is hidden and is not displayed in the. all cells are date formatted the same. Berikut contoh rumus datedif pada microsoft excel. Search for the Function you want to use, and select go. 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 Column C, you can write out the following specific formula: =DATEDIF (A3,B3"Y"). 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. To add a point, it's not suggested to enter content in this bracket TODAY(), if you want to modify the date, you might select a cell then input the date into it the same way you choose C3. Combine All Three Formulas to Get the Actual Age. In Excel 365 this function is still available for backwards compatibility but should not be used. I am trying to show in an Excel table column Yes or No if the date difference between two dates is greater or less than 2 days. Example 1: Common Uses. It creates it using the year in cell E17, and the month in cell E17. DIFF but, because it does not work, I tried also DATEDIF, but there is nothing to do. How to write a DATEDIF. You can simply type =DATEDIF ( in a cell to use it. Can't find any reference to the DATEDIF () function. The problem is that the calculation of days not always is accurate, or at least I don't think. 08 wont to fix the. Open the htm file with Internet Explorer 5. No DATEDIF () Function in the list. Can't find any reference to the DATEDIF () function. The simplest way to calculate age in Excel is to use the Excel Yearfrac Function , which returns the number of years between two dates. Using IF with Subtraction Formula. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏. 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. Enter the function using the TODAY function dialog box. AddColumn(#"Added Custom", "OrderAge", each DATEDIFFLook at the formula below used on an example and we'll show you why we would like to have the INT function to count weeks between dates: =INT( (D3-C3)/7) We take the end date (in cell D3) first and subtract the start date (C3) from it. =TODAY ()-C2. Menghitung jumlah hari, bulan, atau tahun di antara dua tanggal. You need to know the arguments and how to use it. Suppose you are using a DATEDIF formula to find the difference between the dates in B3 and C3: =DATEDIF(B3, C3, "d"). #6. Having trouble with the =DATEDIF function in Excel 2016. Press Enter key then drag fill handle down to the cells for applying this formula. For complete instructions, to c alculate age in accumulated years, months, and days, and to. Report abuse. or. 57650273. Anyways, let’s see how this formula work. The Datedif function is used to calculate interval between two dates in days, months or years. 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 -.