Forum Discussion

Deleted's avatar
Deleted
Mar 11, 2022

DATEDIF returning incorrect value

I'm using the excel function =DATEDIF(start_date,TODAY(),"Y") and for each line this function runs under, I'm getting the incorrect value.    For example: I have an employee who's start date is 3/1...
excel
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 11, 2022

Deleted 

Are you on desktop or online version? If the latest check time zone for SharePoint/OneDrive.

Today is 2022-03-11

  • Hadron4431's avatar
    Hadron4431
    Copper Contributor
    Mar 27, 2024

    SergeiBaklan 

     

    I am using =DATEDIF(A1,TODAY(),"d") in the cell where the return is 9/6/1901 instead of the # of days

     

    2022-07-21$21,500.00 9/6/1901

     

    What am I doing wrong?

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 27, 2024

      Hadron4431 

      In addition, you may use

      =TODAY()-A1

      applying General or Number format to the resulting cell

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 27, 2024

      Hadron4431 

      Select the cell with the DATEDIF formula and set the number format to General.

Resources