Is there a way to calculate age in months if the age in years is zero and also age in days if the age in months is zero. Like the formula should should choose the non-zero between the three? But the priority sequence should be YEARS and MONTH and DAYS respectively. Thank you very much.
sir if i have two same first name but different last name and i modified the latter name in present original table, then in modified table the first and last name of same name got deleted
Sir please give me a formula to search age on the basis of date of birth and joining date supose db is1/2/1966 and j, d is 1/10/1988 so how to calculate age?
Sir, in my excel file i cant get the age in year ... what should i do??? the small icon symbol in headers like calender icon which you change the data type these icon also not come into my excel sheet .. i am using 2016 version of excel ... help us sir .
Hi Vishal, is there any way to calculate to the ageing days and ageing slab. For example.. Date of joining is 1 jan 2018 and last working date is 1 jan 2020 and so.. In power query
Get Certified in Advanced Excel (Power Query):bit.ly/3LdiidF
Use coupon "CZcams12" to get ‘’FLAT 12%’’ OFF at Checkout.
Thank you so much sir...I am getting so much confusion regarding this..
Very useful thanks
The way you explain is very helpful Sir !
Thank You For sharing Knowledge. Its really Useful.
Dear Pawan, Why the value of Age changes once we close and load the power query editor
Thanks...very useful information.
Sir kindly share all the raw excellent file so we can practice it. It will help us lot and make more value addition
Simple and good explaination. Thanks a lot
Thanks solved a big problem for me. Amazed at what power query can do.
Very good knowledge of this video and helpful
awesome explaination
Wow what a teacher 😘👽
It works in ms office 2019
thanks thanks sir
Super sirrr
Excellent
BEST Tutorials. PERIOD.
Bhai dukha to nai zyada?
excellent
THANK YOUUUUUUUU
I'm your fan sir
excellent buddy
Please do a video of power query in the case of multiple sheets summary data to be added in a single sheet
Is there a way to calculate age in months if the age in years is zero and also age in days if the age in months is zero. Like the formula should should choose the non-zero between the three? But the priority sequence should be YEARS and MONTH and DAYS respectively. Thank you very much.
Tried downloading the file for Excel 2013, but while following the steps shown by you the date column shows error.
Total years option is not available in DURATION drop down... I can see Total days, Total hours, Total minutes & Total seconds
Let me know if it has been resolved
is there any option to convet the duration column to years months days, not in decimal/whole number
using this method, does the results always gives +1 year? or was it my system settings related?
can we reuse this formula or every time we have to enter this ?
I don't have total years option in duration column
sir, column ki heating per joh button apke show ho rahe hai, woh mere toh show nahi ho rahe hai g
Can u show how to extract week number
sir if i have two same first name but different last name and i modified the latter name in present original table, then in modified table the first and last name of same name got deleted
please provide data for practice
Do you have a copy of your sample file?
did not show " TOTAL YEARS" on duration option
Sir please give me a formula to search age on the basis of date of birth and joining date supose db is1/2/1966 and j, d is 1/10/1988 so how to calculate age?
Sir, in my excel file i cant get the age in year ... what should i do??? the small icon symbol in headers like calender icon which you change the data type these icon also not come into my excel sheet .. i am using 2016 version of excel ... help us sir .
Exactly the same problem i am facing too
what about months?
Hi Vishal, is there any way to calculate to the ageing days and ageing slab.
For example.. Date of joining is 1 jan 2018 and last working date is 1 jan 2020 and so.. In power query
Hi how do I contact you.