Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2020, 07:47 PM
Marcia's Avatar
Marcia Marcia is offline Calculate age in power query as of a given date Windows 7 32bit Calculate age in power query as of a given date Office 2013
Expert
Calculate age in power query as of a given date
 
Join Date: May 2018
Location: Philippines
Posts: 379
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote
  #2  
Old 11-12-2020, 07:14 AM
Logit Logit is offline Calculate age in power query as of a given date Windows 10 Calculate age in power query as of a given date Office 2007
Expert
 
Join Date: Jan 2017
Posts: 379
Logit will become famous soon enoughLogit will become famous soon enough
Default

Calculate age - Excel
Reply With Quote
Reply

Thread Tools
Display Modes


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
Calculate age in power query as of a given date 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 - Senior Forums

All times are GMT -7. The time now is 06:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft