Formula: =DATEDIF (C4, TODAY (), "y") Date of birth is the start date in the C4 cell. ฟังก์ชันทุกฟังก์ชันใน Excel สามารถหยิบจับมาใช้งานได้ แต่ไม่ใช่กับ DATEDIF ซึ่งนอกจากเป็นฟังก์ชันแห่งความลับแล้ว ยังถือเป็นฟังก์ชันต้องห้าม!Want all of our free Excel videos? Download our free iPad app at Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified. Syntax. mm. Formula to Get Months Between Two Dates (DATEDIF) First, in cell C2, enter the DATEDIF function. 1666, which does complicate things. I want to calculate dates between dates. Syntax: The syntax for the DATEDIF function in Excel is: =DATEDIF(Start_Date, End_Date, Unit) Arguments:Basis: Use basis 1 which tells Excel to divide the actual number of days per month by the actual number of days per year. Step 2: Now Select the cell where you want the age of the person. Open the formula with an open parenthesis. All you need to know is how you use the DATEDIF function to do your task. It creates it using the year in cell E17, and the month in cell E17. 1; 2; Next. )No DATEDIF () Function in the list. To calculate the number of days between two dates (for example "06/05/2023" and "09/15/2024"), enter these dates into the DATEDIF function along with the unit "D" for. Use the DATEDIF function when you want to calculate the difference between two dates. Mar 14, 2011. The DATEDIF function does exactly what the name suggests. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Like in row 6, the DATEDIF function returns 3 months and the YEAR/MONTH formula returns 4. Here is a link to a mini-blog article which contains the same information that you referenced in your message (you may find it easier in the future to refer to my article than an internal message in a forum thread). Go ahead and try the rest of the intervals. Excel SUMIF using text and date ranges defined by cell value. Here is a list of all Recalculate keyboard shortcuts: Shortcut. DATEDIF Units. 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. To round up to the nearest month, see below. Calculating Age in Excel With the DATEDIF function. datepart The units in which DATEDIFF reports the difference between the startdate and enddate. This formula will return whole weeks and the remaining days: =INT( (D3-C3)/7)&" weeks "&MOD(D3-C3,7)&" days". Example 4: When the Day is Not Specified. C. . Reply; Satheesh Babu says:. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. Press Ctrl+1. 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. And when there is a date that is entered in Column A, I want Column G to be able to track that. 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. =DATEDIF(B2, TODAY(), "d") We can then click and drag this formula down to each remaining cell in column C: Column C now shows the number of days that each employee has been with the company. DATEDIF =(LastLogon,todaydate,"d") 5/15/2020 1:48:00 PM and 6/21/2020 12:00:00 AM is 37 days ! Why is the difference ? Which one should I trust ?. Note: these are volatile functions and will recalculate with every worksheet change. Cart. undefined. Syntax: =DATEDIF (start_date, end_date, unit) Start_date : First date in a valid excel format. formule =datumverschil werkt niet / formula =datedif Excel does not work. =DATEDIF (B2,TODAY (),"Y") And immediately, you'll see the. This seems so strange. Messages. If you want a single cell to sum all the individual rows then something like =SUM (IF (DATEDIF (I:I,J:J,"D")>=45,0. Suppose you have the date of birth in cell B1, and you want to calculate how many years have elapsed since that date, here is the formula that’ll give you the result: =DATEDIF (B1,TODAY (),"Y") If you have the current date (or the end date) in a cell, you can use the reference instead of the TODAY. If a workbook is set for automatic recalculation, you do not need to press F9 for recalculation. Package - the zeitraum unit into use when calculating an difference between two dates. 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. Follow the steps to calculate the age using YEARFRAC():. R. Roundup. Replace “date1” and “date2” with the cell references for the two dates, and replace. I'm using DATEDIF function to calculate number of days difference between two dates. Description. Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. It should be in quotes. =DATEDIF (A1;B1;"d") Jun 01 2020 02:49 PM. Neither Excel XP or Excel 2013 are aware of it, so it's pretty strange that it. With the RIGHT mouse button pressed, drag to select the cells to autofill. Add the “ YEARFRAC ” function. Note: We used the DATEDIF() function to calculate the date difference (“d” = in days) between the start date in column B and the current date. Hi there! I am trying to create a formula that will show a blank in column G when there is no value stored in column A. for number of days it should be "d", years should be "y", etc. No DATEDIF () Function in the list. Jadi, untuk menggunakan formula ini, kalian perlu mengetikkan secara manual pada cell yang dimaksud atau pada formula bar yang tersedia. As an example, here is the calculation I am trying to make: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. Next, in the second argument refer to the B2 where you have the ending date. Reply. I use Excel 2013 and scandinavian dates and cannot get DATEDIF-function to work. Jan 13, 2021 at 14:58. Help says use datedif, but the function does not appear in excel! I know there is a way to create a. "M" – (months) the number of full months between two dates. 2) Date calculations involving the last days of a. As a result, the total number of working days returned by Excel is equal to 43. Hi, I have been creating a spreadsheet to show paid, awaiting and overdue invoices. However, the listed three methods are reliable and accurate. Returns the serial number of a particular date. อาการแปลกๆ ของ DATEDIF. The Excel DATEDIF function calculates the time between a start_date and an end_date. Step 3: Implement the datedif in Excel. JoinedUsing the DATEDIF Function. Sometimes this function may result in a wrong. 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. 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. See full list on support. F5=DATEDIF (D5,E5,”y”) // returns 2. If you switch the dates in the formula, you’ll just get a negative number. Right now, if the Date of Birth field (B4) is left blank, the Age. . Aug 15 2022 03:05 PM. "M" – (months) the number of full months between two dates. To fix this, change the number of times Excel iterates formulas: Select File > Options. DATEDIF FUNCTION not functioning as expected. By using the unit options in the DATEDIF function, you can choose the unit of time to calculate the age of the person. I think the only version in which DATEDIF appeared in the formula menu (along with HELP for the function), was Excel 2000. . ago. This function calculates the difference between two dates in a variety of units, such as days, months, and years. New posts New Excel articles Latest activity. Good afternoon, Gurus and Gurettes, I'm working on a much more clumsy, "duct tape-y" solution to my problem and was wondering if someone might offer a more elegant solution in the meantime. Anyways, let’s see how this formula work. It's there, it's just not in the drop-down function list, and the ScreenTip (showing arg options) doesn't show. It is now, but with a warning that the result is not always accurate: DATEDIF function . Dim Msg. It calculates the DATE+DIF (where DIF may be inferred as DIFFERENCE) and gives us the output in our preferred unit. =DATEDIF (E4,E5,"D") Or, you could just use this instead: =E5-E4. You can find information at Chip Pearson's web site for the DateDif Function – Ron Rosenfeld. Hi, I'm wondering how does the DATEDIF FUNCTION calculates when using "Y" unit and "M" unit. Summary. ปี. Arguments. unit – is used to tell the function what difference to return. Sometimes this function may result in a wrong. The DATEDIF Function in Excel. Tip: visit our page about the DATEDIF function to find out how to get the number of weeks, months or years between two dates in Excel. For many years, it wasn't officially documented by Microsoft. Microsoft 365 Education. This video answers these questions: is datedif still in excel. It is important to note that the DATEDIF function is not available in all versions of Excel. But if you see them appear in older Excel models at least you’ll be the full bottle. 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. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function computes the difference between two dates in a variety of different intervals, such number of years, months, or days. Anyways, let’s see how this formula work. Type Alt+7 then space then @ sign (using 7 on numeric keypad) The Excel DATEDIF function returns the difference between two date values in years, months, or days. Suppose you are using a DATEDIF formula to find the difference between the dates in B3 and C3: =DATEDIF(B3, C3, "d")The formula that you use to find out the time between two dates in years and months uses a text string with two DATEDIF functions. Q2. Kindly help to below table no of days calculation. Step 2: First, we must enter the DATEDIF formula in the first row and use “YD” as a unit in a formula. This function takes two arguments: the end date and the start date. Now to add the days, the & operator has concatenated the result of the MOD function. Luckily, it is still there, but you have to know the arguments because Excel won't provide any guidance. You can do it by following the steps below. Um die Anzahl der Tage zwischen einzelnen Datumsangaben zu ermitteln, können Sie die DATEDIF-Funktion verwenden: =DATEDIF(B3;C3;"d") Sie können auch einfach die Daten subtrahieren, um die Differenz zwischen den Datumsangaben in Tagen zu ermitteln. Adding the Sum of 2 Date Ranges using DATEDIF Function (Showing in Years, Months, Days Format) Ask Question Asked 4 years, 3 months ago. end_date - the second or last date. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. C. ในแผ่นงาน Excel ถ้าคุณต้องการคำนวณจำนวนปีเดือนวันหรือสัปดาห์ระหว่างวันที่สองวันที่ระบุไฟล์ DATEDIF ฟังก์ชันใน Excel อาจช่วยคุณได้External YouTube Channel. Description. Next, in cell A4 type your formula DATEDIF (A1,A2,”Y”). อาการนับจำนวนติดลบหากวันเริ่มอยู่ในช่วงปลายเดือน. You can try this for free for 30 days. If the value already contains text, make sure it follows a. Right-click on the cell and click Format Cells (or press CTRL+1) and make sure the cell follows the Text format. Over feeding. DateDif function will return 0, which is appropriate result but DateDiff will return 1 instead of 0. When I say available functions, I meant to say DAYS, DATEDIF, NETWORKDAYS, and. โครงสร้างของฟังก์ชั่นคือ. Important note – Unlike the other functions, the function will not appear as you start to type this date function. Search for the Function you want to use, and select go. Instead you would need to use the corresponding serial number: 42320. names, addresses, E-mails, etc. INT (D5-C5)&” days “ returns the time difference in days. 🙁. For example, given the 01-Jan-19 as the start_date and the 15-Sep-19 as the end_date, you can calculate. Enter the following DATEDIF formula to know the number of months between the two dates. 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. Use the DATEDIF function when you want to calculate the difference between two dates. In the above example, Excel DATEDIF function returns the number of years completed between 01 January 1990 and the current date (which is 14 March 2016 in this example). Example #1: Calculating the number of days between two dates (excluding weekends) In the above example, the Excel NETWORKDAYS function calculates the number of days between 20th December and 10 January. For example, if cell A2. It calculates the DATE+DIF (where DIF may be inferred as DIFFERENCE) and gives us the output in our preferred unit. Security, Compliance and Identity. This function is useful in formulas where you need to calculate an age. I've been typing =DATEDIF (D2, TODAY (),"Y") Excel seems to recognize the first cell as part of the function, but not. The DateDiff function will give you exactly what you need: timestamp1 = "2010-01-10-01. Cell B2 is the End date reference. Upvote 0. Close the parentheses and press Enter. DATEDIF เป็นฟังก์ชั่นที่ใช้หา ระยะห่าง ระหว่าง วัน 2 วัน. Example: 4. What's new. I need the number of months, regardless if full months, over any date period!Option 1: Install the Excel PowerUps Premium Suite add-in. 2251x10^-308). Using the DAYS () function. We would like to show you a description here but the site won’t allow us. You can use the DATEDIF function in Excel to calculate the employment period. In this example, column D contains the date March 1, 2019 and column E contains the date April 5, 2021. Just make sure these dates in double-quotes is in an accepted date format in Excel. 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. Select range. I was using the datedif formula to calculate the days into a positive or negative number and it works great. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has a known bug. The data looks as illustrated below: The formula will be =NETWORKDAYS (B3,C3,D3:D4), giving the result as 43. Education. This one is significantly harder to replicate with other Excel functions, but it. To use the DATEDIF Function to calculate the number of days between dates set the unit of measurement to “d” for days:. This formula will calculate the difference between the dates B1 and B2. I have the. Similarly, Excel provides a built-in function for calculating the number of. While calculating age in excel, you may often want the output (i. Today () function is used to get Today’s date as an end date. @trevorzglobaldd. XLOOKUP function (microsoft. Change the start date to 29 Jan and you'll get 1. Firstly, we will create a new column to input the results. To count the number of whole months between dates, DATEDIF function with “M” unit can be used. This example uses the DateDiff function to display the number of days between a given date and today. DATEDIF. It always goes wrong when you try to calculate months between two month-ends AND the day in the start date is greater than the day in the end date. DATEDIF function. DATEDIF. Then type a formula like one of the following. #3. 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. Let’s see how DATEDIF works, even if the function doesn’t appear to be working in your version of Excel. Top Contributors in Excel: HansV MVP - Jim_ Gordon - Ashish Mathur - Andreas Killer - Shane Devenshire 👏 Choose where you want to search below Search Search the CommunityNo problems with DATEDIF. DATEDIF is intended to calculate the length of a. =DATEDIF (B2,C2,"y")&" Years, "&DATEDIF (B2,C2,"ym")&" Months". As a comment, =end-start returns the same, that's equivalent of above formula. We got the age of Jon Snow using DATEDIF function. . คํานวณจํานวนวัน เดือน หรือปีระหว่างวันที่สองวัน. We want to know how old David is today. e. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. is datedif in excel 2016. unit - tells the function to find the number of days (D), complete months (M), or complete years (Y) between the two dates. 0 Likes. Outlook. INT returns number of work days IN the period, includes start and end date. When you type something like SUM(A1:A10), Excel shows the text string SUM(A1:A10) instead of a formula result. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). It calculates the same results as the above example, but using the DAYS function. In the example shown, the formula in D5, copied down, is: = DATEDIF (B5,C5,"m") Note: DATEDIF automatically rounds down to the nearest whole month. column C has some empty cells. com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Commonly used datepart units include month or second. This is the optional part of the formula. Usage: =DATEDIF(start_date, end_date, unit) Number of days between 2 dates. Because, the DATEDIF function returns the number of complete months elapsed between dates, and this formula works on the months’ numbers that belong to different dates. 1. =DATEDIF (A2,B2,"Y") Explanation – In both formulas, the start_date argument is. It is the DATEDIF function. “m” gets the between dates. Excel. Syntax: =DATEDIF(Date1, Date2, Interval) According to Chip Pearson, this was documented once, in Excel 2000, but has been in Excel since '95 and is treated like other Formulae's drunk cousin (ie Excel knows it lives a happy and useful life, but will not speak of it in polite conversation. It can be used as a worksheet function (WS) in Excel. Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will. You can simply type =DATEDIF ( in a cell to use it. I am trying to correct this formula =DATEDIF(H80,J80,"D")ISBLANK,0)) , where H80 is the start_date, J80 is the end_date, "D" gives me the number of days in between but if one cell is blank to return. 0. I can not find and perform the function. Type: =INT (YEARFRAC (. IFERROR is an elegant way to trap and manage errors. The DATEDIF function calculates the number of years between two dates when the interval argument is specified as “Y” as per its syntax, such as; =DATEDIF ( start_date, end_date, “Y” ) When we apply this function with “Y” interval then it calculates years between two dates a complete calendar year without fractional value. The syntax of the DATEDIF function is DATEDIF (start_date,end_date,unit). you can use Custom format (dd. DAY function. “m” gets the between dates. To use the DATEDIF function, follow these steps: Open a new or existing Excel worksheet and type the start date in one cell and the end date in another cell. “y” gets the Years between dates. Then you'll get precision down to. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). 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. Evaluate. The method is not hard. I know your instructions say to use DATEDIF, but you can just subtract the earlier date from the later date to get the number of days between them. In this case I want to calculate the difference between start date and Today. How can I change my formula to ignore the dates =DATEDIF(B2,C2,"D") Thanks for helping outMicrosoft Excel Tutorial:C. To get the number of months: =DATEDIF(B2, TODAY(), "YM") To get the number of days use the following units:Click in the cell where you want the number of years of service to appear. R. MVP. Re: DATEDIF not working. . To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601 notation, for example, "1954-07-20". The YD parameter instructs the function to suppose that the two dates are no. Trying to get days on a job on my spreadsheet but leave blank if no date entered. For example, if you have two dates in cells A1 and B1, you can use the following formula to calculate the number of. Almost everything is how I want it, apart from one cell that won't quite work. Reply. ). Then we may be able to check the behavior. = (B1-B2)/365. The simplest and most accurate formula to calculate age in Excel is =DATEDIF (birth_date,as_of_date,"y"). I searched Excel help and function reference, and MS knowledgebase. 465000" timestamp2 = "2010-01-10-01. If you want to calculate months or years rounded up, add half a month or half a year to the formula. Learn how to use this hidden function to quickly calculate the difference between two dates, in days, months, or years. Forum Expert Join Date 02-14-2005 Location Worcester, UK MS-Off Ver Excel 2007 (Home) Posts 7,097Excel NETWORKDAYS Function – Examples. you are done. DATEDIF: The DATEDIF function calculates the difference between two dates in various units, such as days, months, or years. When a formula returns an error, IFERROR returns an alternative result. In the above example, we calculate the difference between the start_date in B6 and the end_date in C6 in years. . 1/8/2016 4/7/2016 90. I am currently using the formula =IFERROR(DATEDIF(A7,TODAY(),"d"),"0") but when Column A is blank, Column G. I've tested this function with both UK and US format, both works exactly the same. For the dates 19 Sep 16 to 30 Oct 16 the following formula calculates 41 days. Another useful technique for comparing dates in Excel is to use the DATEDIF function. Forum Guru Join Date 12-31-2011 Location Pittsburgh MS-Off Ver 2002, 2007:2013 Posts 18,890The DATEDIF function (Date + Dif) is a bit of an anomaly in Excel. In column F, we can use the following variations of the DATEDIF function to calculate the difference in years, months and days respectively. =DAYS (B2,A2) + 1. Here is my current formula: =DATEDIF (A3,B3,"m") Which returns whole months, but I would like to break it down to tenths. #2. It's not an official Excel function and exists only for compatibility reasons with older spreadsheet programs (like Lotus-1-2-3). YEARFRAC is another option. To calculate the number of days between date1 and date2, you can use either. Select an empty cell where you want to. And beside, you might want to follow up any notices. 25. To subtract a date from today in Excel, you can use the TODAY () function and subtraction. Flexible Payments. unit : unit in quotes. That's a mandatory part, since some errors can bring unpleasant consequences from re-submission of the full template and completing with missing deadlines and you might be charged a penalty fee. In reply to BillLohne1's post on April 24, 2023. e. Shift+F9. Microsoft in education. Can't find any reference to the DATEDIF () function. I can see that I was missing the y / m / d from part of the formula. Step 1. First, type A1 type 01/12/1990 in cell A1. Windows. . If you want to specify the custom weekends, you can use the NETWORKDAYS. Microsoft Excel. Devices for education. It is not documented and does have some quirks. 1 of 2. Yes, you can use the DATEDIF function to calculate a person’s age. The Excel PowerUps Premium Suite add-in, available on this site, enables an IFS, MAXIFS, MINIFS, SWITCH, CONCAT and TEXTJOIN function (in addition to about 80 other functions) to Excel 2016, Excel 2013, Excel 2010 and Excel 2007. If an Excel function requires a specific data type, such as a number or text, and a cell contains a different data type. Use the DateDiff function in VBA code. Microsoft Teams for Education. In conclusion, the TODAY function is a versatile and useful formula for working with dates in Excel. Want to master Microsoft Excel and take your work-from-home job prospects to the next. It was probably included for compatibility with. In the example shown, the formula in E5 is: =DATEDIF(B5,C5,"y")&" years, "&DATEDIF(B5,C5,"ym")&" months, " &DATEDIF(B5,C5,"md")&" days" where start dates are in column B, and end dates are. DATEDIF ( start_date, end_date, interval ) DATEDIF ( วันเริ่ม, วันจบ, รูปแบบการวัดช่วงเวลา ) โดย interval (รูปแบบการวัดช่วงเวลา) คือ. This is a great function if you work. But I wonder why you want to use that function at all. yy) to see 01. Windows. STEP. Your DATEDIF is generating a number, but I suspect that the cell is formatted to date format, which is presenting the resultant value as a date. Example: You can not enter 11/12/2015 directly into the cell. the age) to be completely represented as let’s say “37 Years, 2 months, 14 days”. Complete days between. Column A is the application date, and column J. “Y” to get the age in years. If you want non-integer precision, you should probably do something simpler without DATEDIF like (A2-A1)*24 or =CONVERT(A2-A1,"day","hr"). Please provide as much info as you. This example shows how to calculate days between two given dates using the DATEDIF function. One use for Excel's DATEDIF function is to calculate a person's current age. This might be something obvious but it is confusing me. However, I want to include the WORKDAY function along with a set of holidays to not calculate. INTL(A3,B3,1))) by giving it a name (very similar to naming a range or. #1. Excel has a 'DATEDIF' function. Lastly, you can use a function called DATEDIF, which is included in Excel from Lotus 1-2-3 days, but isn’t an officially supported formula in Excel. There is a start date a projected end date but I want to know how many days since the start of the job regardless of the end date and leaving blank if no start date entered. We insert m as the unit because we’re looking for the difference in months between the two dates. Now press the ENTER button. However, this function is one of the rare function that is not documented while we enter it. Probably the latter, since DATEDIF is not an official Excel function. If the matter is of calculating a period between two dates, the DATEDIF function serves that exact purpose. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post. Use the IFERROR function to trap and handle errors produced by other formulas or functions. 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". 2. For instance, these dates may be in Column A and Column B. R. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. 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. Cells are as follows: C5 (date due) D5 (date paid) H5 (days overdue) The Days Overdue cell (H5) has the following formula. Just enter =D1 - C1-----PS. Your DATEDIF is generating a number, but I suspect that the cell is formatted to date format, which is presenting the resultant value as a date. I've tried playing around with combining the DATEDIF and IF function, but perhaps I'm using them incorrectly with each other. e. These functions are handy for planning and when writing proposals to determine the timeframe of a project. G. The DATEDIF function will return the number of days between two specified dates. 25 gives you the result as shown below. 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. The first argument is the start date. the datedif function does not show in excel and will not compute a value - even when i change cells and hand enter the equation example.