2. In a new cell, write a formula like this: =C2-B2. Regards, Rory. In the example shown, the formula in E5 is: =DATEDIF(B5,C5,"y")&" years,. So I'm wondering if one or both of those dates just appear to dates properly formatted, but are@geneseesquire . Replied on January 20, 2016. In Excel, we can calculate a person’s age if we know the person’s date of birth and the current date. 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. #1. 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. Bijvoorbeeld, =B1-A1 geeft je het aantal dagen tussen 23-03-2023 en 07-12-1998. What is the syntax for Excel Datedif? The syntax for Excel Datedif is DATEDIF(start_date, end_date, unit). Re: DATEDIF not working. The mysterious datedif function in Microsoft Excel. I'm trying to calculate the difference between two dates in Excel. It should be there, it just doesn't appear in the function list, as it was deprecated long ago. For example, my birthday is on 27th December 1940. We then copy down the formula to get the results for all the other rows, in the result column. First of all, you should avoid passing D2 directly to DATEDIF formula. or. This is about the VBA function DateDiff, not the worksheet function DATEDIF. But I'm not sure about Office 365. 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. Double-click the Format Painter (left side of Home tab). 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. Now it’s time to combine all these to create an accurate age. datedif excel 2010 I can not find "datedif" under excel 2010 . 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. For instance, these dates may be in Column A and Column B. Regards, Amit Tandon. แนวทางการปรับสูตร DATEDIF ให้ทำงานดั่ง. 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". 4. 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. Converting date differences into months and years has always been. . 2: ISOWEEKNUM (date) Returns the number of weeks in the specific year that the mentioned date occurs. EXclude start date, INclude end date We can enter =DATEDIF(C1, D1, "d") But there is no benefit to using DATEDIF for calculating days. Sử dụng DATEDIF một lần nữa với "MD" để tìm ngày. Excel has an incredible function to realize all the different calculation between 2 dates. Replacement Formula - MD Column "D" uses the DATEDIF function and often gives the incorrect answer. Want all of our free Excel videos? Download our free iPad app at DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. Your formula might not return expected results if the cell’s data type can’t be used in calculations. Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. – Mary La Point. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. 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. Menghitung jumlah hari, bulan, atau tahun di antara dua tanggal. of days, ignoring years. =DATEDIF ( วันเริ่มต้น, วันสิ้นสุด, รูปแบบของผลลัพธ์. Education consultation appointment. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Educator training and development. Click in the cell where you want the age to appear. The Datedif function is used to calculate interval between two dates in days, months or years. =DATEDIF(A2, A5, "y") - returns the number of complete years between the dates in A2 and B2. You shall type it on your own, Excel shows nothing while you are entering function. In this Forum, we are Microsoft consumers just like yourself. B4 is populated via NOW() F10 is populated Via another cell with a manually entered date +7 as so D10+7. . Select a formatted range. If the cell is not blank, on the Edit menu, point to Clear, and then click All. From this unit, we can identify the difference in months between a start date and an end date, irrespective of the days and years. What are the options for calulating differneces between two dates? Thanks. 3 people found this reply helpful. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. F6=DATEDIF (D6,E6,”m. For example, to calculate the difference in years between two dates, enter the following. Last Post: 05-27-2018, 10:51 PM. I am using the DATEDIF() and TODAY functions, using Excel 2007, but there are too many days displayed. surely, indeed I tried to use the Italian =DATA. 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. It creates it using the year in cell E17, and the month in cell E17. See screenshot below. The resulting value will be the number of whole days between the two dates. Still using the DATEDIF function above and the units provided, we will be able to get the age in years, months, and days. Report abuse. 25) or =INT (YEARFRAC (start,end)) are not 100% correct. (I found it on this site). First put a start date in a cell, and an end date in another. In your selected cell, type the following formula and press Enter. Fraction between same dates, using the Actual/Actual basis argument. I've variously tried pointing it towards the specific table I want to draw from,. To fix Excel Datedif not working, check the syntax of the function and make sure the dates are in the correct format. I'm using the DATEDIF function to calculate the number of months left on a contract from a start date of 30/11/22 - you can see in the far column that Excel returns two months for contracts that en don 31 Jan and 28 Feb? The third column is also using DATEDIF and recognises the extra month (though I have. 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. Answer. I have the same question (0) Report abuse Report abuse. 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. e. Attention - ExcelForum Rules have been updated as of August 2023. Thus if you do G5-E4, as 05-Mar-2019 - 06. To calculate an age: = DATEDIF (<start date>, TODAY (), "y") Note: The formula TODAY () returns the current date. I am trying to write the formula in such a way that pulls the termination date if the cell is not blank, but uses today's. This formula uses the. อาการนับจำนวนติดลบหากวันเริ่มอยู่ในช่วงปลายเดือน. No problems with DATEDIF. – Ron Rosenfeld. Sure, you can enter the end date to calculate age, not for the current date. If Date format is applied for some reason, it gives the same value but Date format. The first two arguments must be dates: references to cells containing dates, or expressions that evaluate to dates. Calculate the difference between two dates. If the months between the dates cannot. To find the difference between the two dates in Excel, the important thing is to provide the start and end dates to the DATEDIF function. DIFF but, because it does not work, I tried also DATEDIF, but there is nothing to do. Then the 1 represents the first day of that month. Hence it must be typed manually in the formula box. Using the DatedIf function I am. “M”: With this unit, DATEDIF function will return number of complete. 4. . com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. Excel; DatedIf Not Working; DatedIf Not Working. I have a schedule that needs your help. First, "with great details comes great answers". 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. It’ll not even show the function’s name as you enter it in a cell. There are a bunch of units that you can use in the DATEDIF () function. Description. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. Each argument is provided as a number, and the result is a serial number that represents a valid Excel date. Here, Datedif if the function. DATEDIF is the one hidden feature in Excel, but there isn't really a replacement. Then the 1 represents the first day of that month. Press Enter to see your current age. DateDiff takes 3 arguments: DATEDIFF ( datepart , startdate , enddate ) All the arguments can be given as variables as well. Open a new Excel workbook. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. Hoặc có thể đặt 3 phép tính trong 1 ô. 2. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. 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. Hi Rex, so sorry I haven't got back to you sooner I've just been incredibly busy. From the SUPPORT PAGE: Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. ฟังก์ชันทุกฟังก์ชันใน Excel สามารถหยิบจับมาใช้งานได้ แต่ไม่ใช่กับ DATEDIF ซึ่งนอกจากเป็นฟังก์ชันแห่งความลับแล้ว ยังถือเป็นฟังก์ชันต้องห้าม!This will bring up the Insert Function Window. I'm in the U. Whenever I type a function into Microsoft Excel 2013, a small hint box is displayed which lists the function's arguments. There are total 06 units available for this arguments as listed below. . You should get the correct answer for =A3-A2 (ie. 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). You can find information at Chip Pearson's web site for the DateDif Function – Ron Rosenfeld. Modified 3 years, 1 month ago. I've recently found that DateDiff("d", "1/7/1900", "1/8/1900") returns 0 instead of the expected 1. The DATEDIF function may calculate incorrect results under certain scenarios. 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. It is not listed in Excel’s function library, and there are no tooltips to help write the formula. Below I again have the same data set and I want to calculate the duration of service of each employee in years and months. So, it looks like Excel changes a year for <start date> to the same as. For reference, you could view this page: DATEDIF function A difference in complete months, Ignoring days and years. 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. The "E-308" part of the notation means "times 10 to the power of -308", so the number 2. It is not even listed in the "Insert Function" dialog box. By te way, DATEDIF is not needed for this kind of calculation. And there are 3 other dates that have a 0 DateDiff from the next day, 5/6/1900, 6/4/1922, 9/16/1989 This bug also effects the results of date ranges than. 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. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date. 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. For example, if cell A2. And then, the SUM function adds up the values in the resulting array {50; 40; 0} and outputs the final result (50+40=90). For complete instructions, to c alculate age in accumulated years, months, and days, and to. This formula works for the days remaining after full months are counted except when the end date month has 30 days and the billed. 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 ";"). Shift+F9. Forum Guru Join Date 12-31-2011 Location Pittsburgh MS-Off Ver 2002, 2007:2013 Posts 18,890 DATEDIF Function. A good example would be calculating the age. Solved: I am tyring to add the column as follows = Table. Thanks for your help! The isnumber gives TRUE. If you are t…Use the DATEDIF function when you want to calculate the difference between two dates. This is the formula I am using. Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations. In a similar vein, if A1 contains the date 31-Dec-2006 and you use the formula =DATE(YEAR(A1),MONTH(A1)+2,DAY(A1)) you get a. Excel returns 582 in cell D4 meaning there are 582 days between "11/20/2010" and "6/24/2012". . MSFT has been trying to deprecate the use of DATEDIF for many years. =DATEDIF(A1,B1,"y") see here for moreRe: Datedif not working in Excel 2013. Select File * Save as Web Page. 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. Cell A2 is the Start date reference. All you need to know is how you use the DATEDIF function to do your task. MVP. Description. Excel; DatedIf Not Working; DatedIf Not Working. The simplest way to calculate age in Excel is to use the Excel Yearfrac Function , which returns the number of years between two dates. ) and some manually calculated results. 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. (2) Dynamic date difference between two cells, where one is static, and one has dynamic value TODAY (). The syntax of ISBLANK assumes just one argument:If you take a cell containing =TODAY () and format it as general or number then today (March 5, 2019) it will appear as 43529. It's fallen off current Excel menus, but you can still use it. To calculate the number of days, months or years between two dates in Excel, use the DATEDIF function. 2251x10^-308). Then, we will type in the formula “=DATEDIF (C2, TODAY (), “M”)”. Next, refer to cell B1 where you have the ending date. 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: & " ". In Excel, dates are typically stored as numeric values. 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. Formula DATEDIF tidak terdapat pada fitur auto complete pada Excel. HansV MVP. HansV MVP. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. In other words, we can use the DATEDIF function in Excel to convert days to months. Step 2: First, we must enter the DATEDIF formula in the first row and use “YD” as a unit in a formula. This formula works. 17 but you should type date like above. DATEDIF function (microsoft. I placed each DATEDIF statement into a separate cell on Row 2, placed the date in C2, and replaced the literal "04/06/1988" with a reference to C. 1. โครงสร้างของฟังก์ชั่นคือ. Excel ISBLANK function. =DATEDIF (C2,TODAY (),"D") Since you are calculating the difference in days, you do not need to use the DATEDIF function at all. Follow the steps to calculate the age using. In the Save As dialog, select ‘Publish Sheet’ and ‘Add Interactivity’. I have found the Ablebits app and. Fortunately, Excel offers several ways of subtracting dates to get the difference in days between them. DATEDIF will not give any functional tip or hint and neither it will come as part of Insert Function. Type =DATEDIF (. Follow these steps: Enter the two dates in separate cells. Use the DATEDIF function when you want to calculate the difference between two dates. Rory Archibald. 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. But I'm not sure about Office 365. Next, type 15/11/2010 in cell B1. Your second formula should be: =DATEDIF (A3,A2,"d") The later or higher date should come second in DATEDIF & the formula will return 153. To test this out, select the cell and set its format to General. Insert and format the current date and time. To count the months between the dates in cell B3 and C3, please use the formula as this: =YEARFRAC (C3,B3)*12. Then, for the second argument, we have to enter or select the number of days. --HTH RP (remove nothere from the email address if mailing direct) "UOF" <[email protected]> wrote in message news:[email protected]. In A we have start date, in G end date, in C - when we had a meeting. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. In the end, hit enter to get the result. " 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. DATEDIF ensures that you're working with dates rather than date/times. CELL. I have a schedule that needs your help. Have date data that needs structured? The DATEDIF. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. It was probably included for compatibility with. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. YEARFRAC calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). The Excel DATEDIF function returns the difference between two date values in years, months, or days. 5 for example. For example, =DATEDIF (Date1,Date2,"md") returns 28 for Date1 = 1-Feb-2007 and Date2 = 1-March-2009. 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. 11). Excel has had a DATEDIF function for many years. you can use Custom format (dd. Here we can use the simple logical formula to find the Age by using the formula below. In this video, I will teach you How To Calculate Age In Excel From A Date Of Birth using a datedif alternative which is normally not available in all Excel v. 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. Firstly, we will create a new column to input the results. Press Enter key then drag fill handle down to the cells for applying this formula. These are the first and second arguments in our function. For instance, let's say David's DOB is 10/01/1990. From this unit, we can identify the difference in months between a start date and an end date, irrespective of the days and years. I have used the following formula: =IF(DATEDIF(C5,D5,"d")>=2,"Yes"<=2,"No")To find the number of years between two dates. I've been googling and trying everything I can think of and still I'm jammed. First put a start date in a cell, and an end date in another. The method is not hard. UNIQUE () and XLOOKUP () only available to. Using DATEDIF Function to Subtract Dates in Excel to Get Years. 9,212. However, if an additional option Y is provided, like in this example, DATEDIF returns the number of years. 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. Jan 30, 2016 at 2:05 @RonRosenfeld: Interesting. You have to have the whole syntax and the order of elements accurately in order to get an accurate result as well. The DATEDIF formula contains a cell reference for the birth date and for the current date. Using the DatedIf function I am. Education. Well, let me first commend you on a very complicated formula that works. 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. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. This returns the number of years rounded down. Viewed 131 times 0 I'm trying to. Try entering =DATEDIF (A2,B2,"y") in another cell. F2 format General. However, if an additional option Y is provided, like in this example, DATEDIF returns the number of years. However, in the new online product Excel Online (Office 365) this function seems to be not available. 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 lolDATEDIF. Here's how it does this: First the DATE function creates the date, 5/1/2016. 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. 3. In the second example, we have a dataset containing the Name and Birthday of some students. 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. Discussion Options. “m” gets the between dates. Enter the start date and end date in their respective cells. Why is ‘Datedif’ not in Excel? - Quora. The syntax of the DATEDIF function is DATEDIF(start_date, end_date, unit). 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. 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. “y” gets the Years between dates. . 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. 2251 is multiplied by 10 raised to the power of -308 (2. 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. Step 2: Next, start by entering DATEDIF in excel formula. R. Just subtract two dates. This is the easiest way to make a DATEDIF formula in Excel is to input two valid dates in separate cells and refer. No DATEDIF () Function in the list. Fungsi DATEDIF mungkin menghitung hasil yang tidak benar di bawah skenario tertentu. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. Compute Age as Years, Months, and Days. The Excel DATEDIF function returns the difference between two date values in years, months, or days. The DATEDIF function may be the solution you are looking for in your spreadsheets!I'm Josh with Evergreen Tutorials and. 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". A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. Microsoft in education. Using the DatedIf function I am. 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. One little known way is to use the secret Excel DATEDIF function. 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. mm. The problem is not with your version of Excel; the DATEDIF function is an undocumented function. Calculating Number of Complete Years. But if you know the syntax, which I’ll share with you in a moment, you can use it for a range of applications. "MD" trả về số ngày còn lại trong tháng. However, you can manually type the DateDif formula into a cell and by following the instructions in this post, get the results described. It is important to note that the DATEDIF function may not work correctly if the start date is after the end date. You can delete Z1. STEP. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. [SOLVED] DATEDIF - DATEDIF Calculation returning a negative for days or months. I just tried to update, but it is already up-to-date. Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. Something went wrong. Excel General. I have the following formula in a report field. Our videos are about below Microsoft Reporting Tools:Excel Basic. Suppose the person’s date of birth is in cell A1 and the current date is in cell A2. The. DATEDIF. SINGLE() in pre-dynamic array Excel. Note: these are volatile functions and will recalculate with every worksheet change. You will have to write complete syntax of DATEDIF. Answer. DATEDIF function: Calculates the number of days, months, or years between two dates. Subtract times. Click in the Date 2 box and select a cell with the second date. 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 -. Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations. This thread is locked. microsoft. Type ,TODAY (),”Y”) & ” Years and ” & DATEDIF (. DATEDIF function (microsoft. First, enter the DATEDIF function in cell C1. Regarding DATEDIF not being accurate, do bear in mind the following warning from Microsoft regarding the DATEDIF function. Then I copied the formula (and its format) down the column. I now need to change it to calculate the datedif from the date which is a result of a workday. I can not find and perform the function. 4. 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. Microsoft 365 Education. Excel 'datedif' Fonksiyonu (Çözüldü). Even now. Combine All Three Formulas to Get the Actual Age. I don't know how I oversaw this error, and less do I know why the internet says. You May Also Like the Following Excel Tutorials: Count the number of workdays between two dates. While typing this function in a cell in Excel, it would NOT show the IntelliSense. How to use The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. See the below given image. Now, we will show you how you can count their age using the DATEDIF and TODAY functions in Excel. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. Bentuk umum formula DATEDIF adalah sebagai. And again, 12/31/2019 is after that. DATEDIF is the easiest way to find out how many years are between two dates. If you author or edit a formula in dynamic array Excel that contains the @ operator, it may appear as _xlfn. I. "Y" is the reference to the year's parameter in. 11. 25) and then reduced to 1 decimal which actually works great for me, maybe not for others though, hope this. Note: DATEDIF function will exclude the start date when counting the month numbers. DATEDIF calculates the number of years, months, and days between the two dates, yielding your age. It creates it using the year in cell E17, and the month in cell E17.