Forum Discussion
Friso1966
Jun 16, 2019Copper Contributor
Missing functions in Excel
I am currently using the latest build of Excel as part of my Office 365 subscription. I have noticed that a number of functions that I would like to use within formulas are not available. The functio...
- Jun 17, 2019Datedif is the only function not available in the list (for historic reasons) that is actually there. Just type the entire function name.
Friso1966
Jun 17, 2019Copper Contributor
JKPieterse Thank you for your response and for outlining the requirements for using SORT, UNIQUE and FILTER.
Unfortunately, DATEDIF is still missing as shown whenever I try to type the function into a cell.
Have you come across this before?
JKPieterse
Jun 17, 2019Silver Contributor
Datedif is the only function not available in the list (for historic reasons) that is actually there. Just type the entire function name.
- Friso1966Jun 17, 2019Copper Contributor
Unbelievable. It works now. I used DATEDIF without it appearing in the list and it works as expected. Thank you for your assistance with this problem.