Share via

DateDif function is not available in ms excel 2016

Anonymous
2017-03-15T11:06:38+00:00

Hi,

DateDif function is not available in my MS Excel 2016. When i use =Datedif, nothing comes.

Please tell me how to find Datedif function in MS Excel 2016.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-15T11:31:12+00:00

    DATEDIF is not a standard function and hence not part of functions library and so no documentation. Microsoft doesn't promote to use this function as it gives incorrect results in few circumstances.

    But if you know the arguments, you may use it and it will work and in most of the cases will give correct results.

    52 people found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2017-03-15T11:43:28+00:00

    It has been officially recognised and introduced by Microsoft in Excel 2016 and is present in Help also. It doesn't appear in Insert Function list though. Hence, it doesn't pop up the syntax of DATEDIF if DATEDIF is written.

    OP needs to write the complete syntax of DATEDIF to make this workable.

    (For OP - https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c?ui=en-US&rs=en-US&ad=US)

    44 people found this answer helpful.
    0 comments