Convert Integer to Date in Excel issue

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