Share via

==datedif(G2,today(),"y")datedif(G2,today(),"y")

Anonymous
2024-03-11T13:46:01+00:00

Why does this formula not work on my excel? I am trying to calculate years or service
=datedif(G2,today(),"y")

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-11T14:34:38+00:00

    Hi Mariska M!

    I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

    There could be a few reasons why it might not be working as expected:

    • Ensure that cell G2 contains a valid date formatted as a date in Excel. If the date is not recognized as a valid date, the formula will not work correctly.

    To do that: Right-click on the cell and select "Format Cells". Under the "Number" tab, ensure the category is set to "date" or "General" and not a format like "Text" that would display the formula itself instead of the calculated result.

    • Double-check that the cell reference G2 points to the correct cell containing the start date for calculating the years of service.

    Please let me know how it goes and if you need any other assistance and I will be more than happy to help further.

    Thank you

    Best Regards, Shakiru

    Was this answer helpful?

    0 comments