Something strange with date calculations

It seems like Excel doesn't count the 31st December as the 365th day in a common year. Instead it is using the number of day in a leap year (366 days) to caculate its dates. When I was transforming ...