Working out a person’s age from a date of birth or calculating full years of service from an employee start date or finding out how long you’ve owned a car, laptop, or any other asset. These are all very common Excel problems and to solve them most people still reach straight for formulas. In this video, I show you a much simpler approach using Power Query. No worksheet formulas. No complicated M code. Just a handful of clicks
Power Query is built into Excel (nothing extra to install or pay for), and it’s ideal for calculations like age and service length where accuracy really matters, especially around birthdays and anniversaries.
Download a copy of the file(s) used in this video: https://share.zight.com/6qu4r6Re