Converting the Number of Days to Year Month Day Conversion

File teaching Converting the Number of Days to Year Month Day Conversion operation.

Excel Source: Converting the Number of Days to Year Month Day Conversion

It is possible to produce results in terms of year, month and day from the total day information. The effect of leap year differences in the calculation has been taken into account. An attempt was made to reduce deviations caused by rounding in the calculations. It is intended that the results can be used for service time and similar tables.

Hope it is useful.