Calculate age in power query as of a given date

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate age in power query as of a given date

FAQ

Thread Tools

Display Modes

11-11-2020, 07:47 PM

Marcia

Windows 7 32bit Calculate age in power query as of a given date

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Calculate age in power query as of a given date

Hi. I know how to calculate the age of persons in PQ from DOB to TODAY under the Date tool of the Add Column tab. I want to add another column that will compute the age from DOB to December 31, 2020. I could not find a solution in my search.

Thank you.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove delimiters in merged columns in power query when null	Marcia	Excel	2	11-06-2020 09:42 PM
Format numbers in Power Query	Marcia	Excel	2	09-21-2020 12:59 AM
Do I need a power query for this one?	shabbaranks	Excel	5	04-10-2019 03:29 AM
Issues Using Power Query file in Excel 2016 and then in 2013	bld9936	Excel Programming	0	02-27-2017 12:50 PM
Query and Power Query not working Excel 2016	bl10	Excel	0	07-22-2016 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 PM.