Why doesn't Excel display argument hints for DATEDIF()?
Whenever I type a function into Microsoft Excel 2013, a small hint box is displayed which lists the function's arguments.
For some reason, this hint box doesn't appear when using DATEDIF(). I can't find it listed anywhere on the formula tab, nor am I shown any reminder of what arguments to use. Excel won't even autocomplete the formula name while typing.
Returns number of days between Nov 15-Nov 20
The formula works as expected once entered, but it's difficult to use properly when I need to have the arguments memorized.
Why isn't Excel displaying argument hints for DATEDIF()?
DATEDIF is an undocumented function in Excel
Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios.
For some reason Microsoft [doesn't] think the DATEDIF function is worthy of any documentation since Excel 2000. In fact they say they only include it in recent versions for backward compatibility.
Microsoft no longer supports this function in Excel. You can still use it, but you don’t get any help with it.
A suggestion is: UDF replacement for Excel's DATEDIF function
Also visit:
- How to change Chart xAxes font color from black to red via vba code?
- using VBA in Excel I would like to replace only blank cells with a formula without selecting all the time
- If value matches x, enter new value into another table using row and column matches
- Create a smaller dynamic list in Excel from data in a larger list using multiple criteria
- How to loop through dimetial array using VBA in excel?
- Correct calculation of r square (R^2) using visual basic WorksheetFunction.LinEst function
- Copy column data to new column, if data exists, use column to the right
- Best practice for checking if an cell entry will generate an error
- Spill formula to sumifs by row & col for only relevant months
- How to keep value of merged cells in each cell?
- Python - Automatically adjust width of an excel file's columns
- How to Define the row after Lastrow in VBA
- How to convert big numbers between HEX and DEC in Excel without using VBA?
- Preventing ClearContents on Combination of Merged and Unmerged Cells
- drop_duplicates not working in pandas?
- Word VBA: How to reference a Named Range/Cell from Excel so it returns the row number
- Convert excel to pdf with VBScript
- Forbidden custom function name in Excel
- copy file to a dynamic folder using VBA
- VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
- Pie chart with three fields in Ms Excel
- Excel: Put formula in next row after header text, like in Google Sheets
- Copy cells based on matching index numbers on excel?
- Adding holiday parameter into NetworkDays function
- Split a cell into 2 rows in Excel
- How to Combine Text Based on Multiple Criteria in Excel
- The VBA code slows down the worksheet needs to be faster
- Dealing with struck-through and non-struck-through characters using Python on Linux and/or MacOS
- Renaming worksheets by VBA
- Add Table to Excel File with R, without overwriting excisiting content