Excel datedif not found. 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. Excel datedif not found

 
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 datesExcel datedif not found Calculating Age in Excel With the DATEDIF function

Step 4: Enter the end date as B2 in cell C2. . By DaveBre in forum Excel Formulas & Functions. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Excel DATEDIF not showing the correct answer. In Excel, we can calculate a person’s age if we know the person’s date of birth and the current date. I have the. The. Excel General. Re-type 01/01/2017 and 01/01/2018 . 2. DATEDIF is just designed to return whole numbers. 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. It pretends like it's not there. 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. Using DATEDIF Function to Subtract Dates in Excel to Get Years. First put a start date in a cell, and an end date in another. Let's say that cell A1 contains someone's birthdate, and cell B1 contains the current date. Step 3: Enter the start date as A2 in cell C2. DatedIf Not Working. The DATEDIF calculates the months between the dates. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. 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. Ask Question Asked 3 years, 1 month ago. 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. #1. The DATEDIF Function typically calculates the number of days between two dates. Fortunately, Excel offers several ways of subtracting dates to get the difference in days between them. It creates it using the year in cell E17, and the month in cell E17. Creating a holiday calendar in Excel. ฟังก์ชัน DATEIF คืออะไร ? ฟังก์ชัน DATEDIF เป็นฟังก์ชันหนึ่งของแอป Excel และ Google Sheet ที่ใช้คำนวณความแตกต่างของข้อมูลวันที่ ในตารางคำนวณเส. แนวทางการปรับสูตร DATEDIF ให้ทำงานดั่ง. [Sidenote: I am using the German Version, so I am actually missing the functions =EINDEUTIG () and =XVERWEIS () but either or - these functions are missing in my Excel] Nup, you need to upgrade to a new version or write your own logic in VBA. NOTE: If you want to calculate the age at a specific date, replace the TODAY () function with. I have tried using "w" and "ww" and these only count the number of weeks. If you want a static value, use date and time shortcuts. Follow the steps to calculate the age using. Note: Excel won't help you fill. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. 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. Dùng hàm datedif để tìm ngày. you can use Custom format (dd. Show dates as days of the. This function returns the number of whole days, months or years between Start date and End date. . If you want to use Current date then use this formula in cell T2: =DATEDIF (R2,TODAY (),"Y")&" Years "&DATEDIF (R2,TODAY. Excel won't even autocomplete the. 25. See below for examples and an. Just enter =D1 - C1-----PS. I found DATEDIF function to be inconsistent in calculating dates. A suggestion is: UDF replacement for Excel's DATEDIF. Your formula might not return expected results if the cell’s data type can’t be used in calculations. I was using the datedif formula to calculate the days into a positive or negative number and it works great. Below is the formula that will do this: =DATEDIF (B2,C2,"y")&" Years "&DATEDIF (B2,C2,"ym")&". HansV MVP. Click a cell where you want to locate the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:. It’ll not even show the function’s name as you enter it in a cell. Trying to retrieve the number of months between the two dates below. I've used Datedif successfully on a number of projects, but have found it to calculate a bit inaccurately on certain calculations. Excel IF function with Datedif function nested. =DATEDIF ( วันเริ่มต้น, วันสิ้นสุด, รูปแบบของผลลัพธ์. Apply DATEDIF & TODAY Functions to Count Age in Excel. However, there is an easy workaround. 1 Answer. Can't find any reference to the DATEDIF () function. DATEDIF (C3,D3,"M"), the result being 3 months. 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. Step 2: First, we must enter the DATEDIF formula in the first row and use “YD” as a unit in a formula. The functions that I am currently attempting to use are DATEDIF, SORT, UNIQUE and FILTER. Using the DatedIf function I am. The first part of the formula is an exact copy of the formula used to return complete months i. DATEDIF function is very useful in calculating any age in Excel. unit : unit in quotes. . This formula works. In the example shown, the formula in E5 is: =DATEDIF(B5,C5,"y")&" years,. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. 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. The DATEDIF Function. Use the DATEDIF function when you want to calculate the difference between two dates. DATEDIF ไว้ใช้ทำอะไร? DATEDIF เป็นฟังก์ชั่นเกี่ยวกับวันที่ ใช้หาว่าวันสองวันที่กำหนด ห่างกันกี่วัน กี่เดือน หรือ กี่ปี (เราเลือกได้) วิธีการใช้ฟังก. 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. For some reason, Microsoft has decided not to. This is a great function if you work. Bentuk umum formula DATEDIF adalah sebagai. “m” gets the between dates. Dates in Excel start from 01/00/1900 (Assuming you're using US format of mm/dd/yyyy) and are stored as 01/00/1900 + n days. ฟังก์ชันทุกฟังก์ชันใน Excel สามารถหยิบจับมาใช้งานได้ แต่ไม่ใช่กับ DATEDIF ซึ่งนอกจากเป็นฟังก์ชันแห่งความลับแล้ว ยังถือเป็นฟังก์ชันต้องห้าม! This will bring up the Insert Function Window. For example, =DATEDIF (Date1,Date2,"md") returns 28 for Date1 = 1-Feb-2007 and Date2 = 1-March-2009. Using the DatedIf function I am. 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. The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. Select a formatted range. The simplest way to calculate age in Excel is to use the Excel Yearfrac Function , which returns the number of years between two dates. Now follow the instructions at the top of that screen. . It appears that what I'm trying to do obviously doesn't work on Ranges. Cell B2 is the End date reference. 1. 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. 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". However, if an additional option Y is provided, like in this example, DATEDIF returns the number of years. I have noticed that a number of functions that I would like to use within formulas are not available. 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. Step 3: Press Enter to get the result, which will be the difference in months between the two dates. Select File * Save as Web Page. Just enter =D1 - C1-----PS. 2251 is multiplied by 10 raised to the power of -308 (2. In general, the DATE function is the safest way to create a date in an Excel. The expected answers are below. You pass 0 and D2 ( C2 - B2 ). The start_date and end_date arguments are required while the unit argument is optional. For example, my birthday is on 27th December 1940. You will have to write complete syntax of DATEDIF. =DATEDIF (C2,TODAY (),"D") Since you are calculating the difference in days, you do not need to use the DATEDIF function at all. To begin, enter 0 as the function’s first argument. Excel DATEDIF Formula . Column "E" uses the formula shown. The following is an example of a datedif formula in Microsoft Excel. , use the previous two shortcuts subsequently with a space) to enter a static date as well as time. 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. In Column C, you can write out the following specific formula: =DATEDIF (A3,B3"Y"). Just subtract two dates. you can use Custom format (dd. I have used the following formula: =IF(DATEDIF(C5,D5,"d")>=2,"Yes"<=2,"No")To find the number of years between two dates. yy) to see 01. Even now. yy) to see 01. Therefore, dates entered in this format are not recognized as dates and result in erroneous calculations. 3: FORMULATEXT (reference) Returns a formula as a text string. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. end_date : Second date in a valid excel format. 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. DATEDIF is the easiest way to find out how many years are between two dates. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. . Follow the below steps to Find Age using Simple Math: Step 1: Enter DOB or Start_date into the cell. Thus if you do G5-E4, as 05-Mar-2019 - 06. Formula in cell D4: =DATEDIF (B3,C3,"D") The third argument determines the unit to calculate, in this case, it is "D" which stands for day. And again, 12/31/2019 is after that. In addition, there is no tooltip for DATEDIF (). g. It's in the format of =Date("y","m","d"). Flexible Payments. 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. DATEDIF function (microsoft. Shift+F9. The above is as suggested by Sergei Baklan in the thread below. How the formula works. Please find the screenshot below. 25) and then reduced to 1 decimal which actually works great for me, maybe not for others though, hope this. 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". com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. . CELL. 4. Formula for this unit is =DATEDIF (start_date, end_date,”ym”) So the given example shows the answer 6, as the difference between month # 7 and month # 1. Hello there, I am trying to create a spreadsheet showing the daily charge to six decimal places using DATEDIF so that I can input a start and end date: SftvZCc. Last Post: 08-27-2015, 06:22 PM. I was able to get the result I wanted to achieve with one one date condition and return the value if it matched but I'm not able to enter multiple date ranges, as well as return values if they matched. INTL(A3,B3,1))) by giving it a name (very similar to naming a range or. Open a new Excel workbook. When calculating date intervals, DATEDIF uses the year of Date1, not Date2 when calculating the yd, ym and md intervals. Trong ô C4, hãy dùng công thức DATEDIF bằng tham số "MD" . The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. Let's say that cell A1 contains someone's birthdate, and cell B1 contains the current date. Enter the function using the TODAY function dialog box. Report abuse. learner_254. Excel sees you are calculating with dates and thinks you want to display the result as a date as well. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Note: Excel won't help you fill out the arguments for DATEDIF like. "YM" - The difference in months between <start date> and <end date> ignoring years. DATEDIF calculates the number of years, months, and days between the two dates, yielding your age. Using the DatedIf function I am. The syntax of the DATEDIF function is DATEDIF(start_date, end_date, unit). 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. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. 1. I found a solution =((DAYS(TODAY(),E2))/365. Type of abuse. Cell references are formatted as dates. In Excel, dates are typically stored as numeric values. " 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. My formula is thus DatedIF (earlier date/beginning of the amortization period, the month end date,"m") + 1. In your case, try with: Duration = DateDiff ("n", fValue, lValue) If you like to. The result will be displayed in the selected cell. It should be there, it just doesn't appear in the function list, as it was deprecated long ago. "MD" trả về số ngày còn lại trong tháng. . DATEDIF is practically an insider tip, as the function is not even included in the internal list in the software. I've variously tried pointing it towards the specific table I want to draw from,. The formula =DATEDIF (A1,B1,"y") returns the age in years of that person. This is the formula I am using. Example 1: Common Uses. From the SUPPORT PAGE: Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. C. Formula for this unit is =DATEDIF (start_date, end_date,”ym”) So the given example shows the answer 6, as the difference between month # 7 and month # 1. =DATEDIF ("12/4/2013","1/1/2015","Y") Returns 1 because whether from December 4, 2013 or April 12, 2013 there is over a year and less. 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. But as long as you know that it's there and you know how it works. 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. Using the DatedIf function I am. Attention - ExcelForum Rules have been updated as of August 2023. Compute Age as Years, Months, and Days. Then you'll get precision down to. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date. Something went wrong. DATEDIF function is very useful in calculating any age in Excel. 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). Next, type 15/11/2010 in cell B1. The 1 indicates that the function should use the actual day count, instead of a different. You can still use it. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). Jan 30, 2016 at 2:05 @RonRosenfeld: Interesting. Please remember that array formulas should be completed by pressing the Ctrl + Shift + Enter shortcut. Education. Silakan lihat bagian masalah umum di artikel ini untuk detail selengkapnya. if C1 is blank and time interval between two dates (G2 and today) is more or equals F2-2, then ''Attention". 2251E-308. CELL. There are a bunch of units that you can use in the DATEDIF () function. - this is per every forum I've found. The problem is that the calculation of days not always is accurate, or at least I don't think. We have to enter this argument in between two double inverted commas ex: “Unit”. Check Difference option from the Type section;; In the Arguments input textboxes, select the cells which. In this example, column D contains the date March 1, 2019 and column E contains the date April 5, 2021. 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 lol 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 lol We would like to show you a description here but the site won’t allow us. 2: ISOWEEKNUM (date) Returns the number of weeks in the specific year that the mentioned date occurs. I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. In the first method, we will be using the IF function and the basic subtraction formula. simply subtract the smaller date from the later date. Mode is a bit different – it has to be one of six in-built text codes (that is, entered with. e. Uses a 365 day basis. Hence it must be typed manually in the formula box. =DATEDIF (start,end,unit) Here's the info page at MS for a reference of the units. You should get the correct answer for =A3-A2 (ie. mm. I now need to change it to calculate the datedif from the date which is a result of a workday. Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. 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. For example, if cell A2. Excel has an incredible function to realize all the different calculation between 2 dates. You can simply type =DATEDIF ( in a cell to use it. You shall type it on your own, Excel shows nothing while you are entering function. DATEDIF requires first 2 arguments as a date. อาการนับจำนวนติดลบหากวันเริ่มอยู่ในช่วงปลายเดือน. The DATEDIF Function typically calculates the number of days between two dates. C. You can paste formatting multiple times. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. DATEDIF เป็นฟังก์ชั่นที่ใช้หา ระยะห่าง ระหว่าง วัน 2 วัน. 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. Web. 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. It creates it using the year in cell E17, and the month in cell E17. YEARFRAC is another option. If dates are not derived from functions then the DATEDIF returns "3". May 01 2022 08:23 AM. We would like to show you a description here but the site won’t allow us. F5=DATEDIF (D5,E5,”y”) // returns 2. 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. Since 12/31/2019 is after that, it makes sense for DATEDIF to return less than 2, namely 1. "Y" is the reference to the year's parameter in. Discussion Options. 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 ";"). So, it looks like Excel changes a year for <start date> to the same as. . 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. Education consultation appointment. DATEDIF function (microsoft. 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. I don't know how I oversaw this error, and less do I know why the internet says. Sorted by: 0. e. This returns the number of years rounded down. SyntaxThe mysterious datedif function in Microsoft Excel. VDOM DHTML tml>. Step 1. R. Re: calculate datedif if mutiples conditions within a range are met Hi @waglagla Trying to apply it to a full range in one formula gets tricky and may require an arrayNo problems with DATEDIF. How to write a DATEDIF. Apply a date number format to display the output from the DATE function as a date. 1: DAYS (start_date, end_date) This will determine the number of days between the indicated two dates. =DATEDIF(A2, A5, "y") - returns the number of complete years between the dates in A2 and B2. I'll try to explain why I need this - we have deadlines, different tasks have different amount of days to complete them. N. You can paste formatting multiple times. D3-C3 gives us the answer in days i. Regards, Amit Tandon. Q2. The DATEDIF function may calculate incorrect results under certain. In the Date & Time Helper dialog box, do the following operations:. Hello there, I am trying to create a spreadsheet showing the daily charge to six decimal places using DATEDIF so that I can input a start and end date: SftvZCc. A good example would be calculating the age. Dates are generated through functions beneath. 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. This thread is locked. In this Forum, we are Microsoft consumers just like yourself. Go ahead and try the rest of the intervals. As you can see in the result we have 7 which is the. Calculate the difference between two dates. A and ignoring zero values. We have selected cell C2 in this case. From this unit, we can identify the difference in months between a start date and an end date, irrespective of the days and years. However, it works in all versions of Excel. There are a bunch of units that you can use in the DATEDIF () function. Answer HansV MVP MVP Replied on January 20, 2016 Report abuse There is no DATEIF function, I suspect that you want DATEDIF. Add an open parenthesis directly after the "F" in your "=DATEDIF" entry. Next, refer to cell B1 where you have the ending date. Using the DatedIf function I am. 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. This formula will calculate the current age in full years – for example “32”. The resulting value will be the number of whole days between the two dates. Note: these are volatile functions and will recalculate with every worksheet change. First put a start date in a cell, and an end date in another. Have date data that needs structured? The DATEDIF. 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. It's for a spreadsheet that tracks Paid Time Off which which accrues at a different rate depending on how long the employee has worked for the organization. A compatibility function that comes originally from Lotus 1-2-3, Excel will not help supply arguments when the function is entered. However, the DATEDIF function can also take an array of dates as the. . Can't find any reference to the DATEDIF () function. 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. Here we can use the simple logical formula to find the Age by using the formula below. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. Calculating Age in Excel With the DATEDIF function. For a long time, official documentation on DATEDIF was sparse. I suspect that there are quite a few. Select cell WC2000 and scroll the sheet such that cell WC2000 is the first cell on the left. There is one older way, the DATEDIF () function, that Microsoft no longer supports. But if you know the syntax, which I’ll share with you in a moment, you can use it for a range of applications. Enter your birthdate in one cell of Excel and the DATEDIF formula into a different cell. It’ll not even show the function’s name as you enter it in a cell. Reply;. To fix Excel Datedif not working, check the syntax of the function and make sure the dates are in the correct format. Then the 1 represents the first day of that month. MVP. What works: (1) Date difference between two static cells. Save to an htm file on your hard drive (any file name). Others have found equivalent formulas although. Description. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Use the DATEDIF function when you want to calculate the difference between two dates. Excel DATEDIF function is provided for compatibility with Lotus 1-2-3. 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). For many years I have used the following formula to calculate the difference between an entered date & the current date in Years, Months, Days. The "Date" function would work for your purposes. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. Firstly, we will create a new column to input the results. I have a schedule that needs your help. Now, in the third argument, you need to enter the unit “y” to get the count of years. This is about the VBA function DateDiff, not the worksheet function DATEDIF. Excel; DatedIf Not Working; DatedIf Not Working. Originally Posted by Peterino. 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. Menghitung jumlah hari, bulan, atau tahun di antara dua tanggal. I am currently using the latest build of Excel as part of my Office 365 subscription. Anyways, let’s see how this formula work. The syntax of the DATEDIF function is DATEDIF(start_date, end_date, unit). Select cell D4. 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. However, in the new online product Excel Online (Office 365) this function seems to be not available.