1. How do I handle Leap years when calculating age in Excel? Answer: Instead of 365 days, you can use 365.25 days in your ageing formulas as Leap years come once every four years. However, this will return inaccurate results sometimes. Using theDATEDIFfunction is more convenient. 2. How ...