Forum Discussion

Tjarliman Rusadi's avatar
Tjarliman Rusadi
Copper Contributor
Jan 22, 2018

Convert Integer to Date in Excel issue

Hi,   Currently I have issue regarding converting integer to date in Excel. If I put 60 in one of the cell, then I convert it to Date it become 29-Feb-1900 which is not correct. If I put 61, ...
excel
Formulas and Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 22, 2018

Hi,

 

The cells in which you entered numbers are formatted as dates!

Just select these cell, go to Home >> Number and then select General Format or Number format.

Or do select these cell and then press (Ctrl+Shift+~) to apply the General Format.

  • Tjarliman Rusadi's avatar
    Tjarliman Rusadi
    Copper Contributor
    Jan 22, 2018

    Hi,

     

    Thanks for replying.

    Actually what my question was about the result of the conversion. It is not correct, since for example for integer 60, if we convert it to date the way you told me, the result would be 29 Feb 1900 which is not correct. Because 1900 is not a Leap Year, hence it doesn't have 29 Feb.

    Another example is, if we have an integer 61 the result is 01-Mar-1900 which is not correct either, it supposed to be 61 => 02-Mar-1900 and 60 => 01-Mar-1900.

    So, if we convert an integer bigger than 59 the result would be not correct.

     

    You can check too if you want.

     

    Regards,

    Tj

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Jan 22, 2018

      Don't care much about this.

      No matter if the sequential serial number of each date is increased by one, this is just a representative number used to give the ability to perform mathematical operations on dates.

       

      If you're upset about this, you can use the https://support.office.com/en-us/article/date-systems-in-excel-e7fe7167-48a9-4b96-bb53-5612a800b487!

      But I don't recommend it!

       

Resources