Monday, October 31, 2022

Get Age or Years in Service with Power Query

Trying to figure out the age of a person based on their birthdate. Or you want to know how long someone has worked at your company or organizations. If it one to three people you're calculating this for, it's easy to manually do it. But it there is a long list of names on a spreadsheet and you've got to maintain it on a long term basis, there should be a more automated way to do this. This video will show you two general ways to do it ; one example using functions and another using Power Query.

No comments:

Post a Comment