Share via

DATEIF function missing from my Microsoft 365 - how do I get it?

Anonymous
2023-04-24T16:52:15+00:00

I seem to be missing one Date function - I use it often. How do I get that function? All other date functions are present. I have tried repairing from the network, but while the update completes, the DATAIF function is still missing.

Thanks for any help you can offer.

Bill

Microsoft 365 and Office | Excel | For business | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-24T17:19:42+00:00

    The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions.

    You can still use it.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-04-24T17:12:00+00:00

    Thank you. However, while I think I know what it does, it's not available on my Excel application. I would like to find out why it is missing and how to get the function installed and made available to me.

    Bill

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-04-24T16:56:46+00:00

    DATEDIF function: Calculates the number of days, months, or years between two dates.

    Was this answer helpful?

    0 comments