Freigeben über

DATEDIF Function Excel - Office 365

Anonym
2020-07-07T08:15:55+00:00

Hello everyone,

could you please help me ?

The function DATEIDIF works only for months and for nothing more, for year, day etc. unfortunately not.

I use german version of excel.

Many thanks in advance!

BR

Mina

Microsoft 365 und Office | Excel | Für Zuhause | Windows

Gesperrte Frage. Diese Frage wurde aus der Microsoft-Support-Community migriert. Sie können darüber abstimmen, ob sie hilfreich ist, aber Sie können keine Kommentare oder Antworten hinzufügen oder der Frage folgen.

0 Kommentare

5 Antworten

Sortieren nach: Am hilfreichsten
Am hilfreichsten Neueste Älteste
  1. Anonym
    2020-07-07T11:16:02+00:00

    Great, glad to have helped.

    Kind Regards,

    Elise

    0 Kommentare
  2. Anonym
    2020-07-07T09:48:19+00:00

    Now works. This was because I am using an office in german.

    Many thanks :)

    BR

    Mina

    0 Kommentare
  3. Anonym
    2020-07-07T09:20:58+00:00

    Can you check using the formula here, as I can get it to work using this

    Kind Regards,

    Elise

    0 Kommentare
  4. Anonym
    2020-07-07T09:17:19+00:00

    Hi Elise,

    Thanks, but unfortunately it does not work. It work only for month :(

    Have a nice day

    BR

    Mina

    0 Kommentare
  5. Anonym
    2020-07-07T08:59:40+00:00

    Hi, I'm Elise, an independent advisor and I'd be happy to help with your issue.

    To use DATEDIF use the format:

    DATEDIF( start_date, end_date, interval )

    Replace 'start_date' and 'end_date' then for 'interval' use one of the following:

    Y The number of complete years.

    M The number of complete months.

    D The number of days.

    MD The difference between the days (months and years are ignored).

    YM The difference between the months (days and years are ignored).

    YD The difference between the days (years and dates are ignored).

    Kind Regards,

    Elise

    0 Kommentare