Excel Calculate Age using Date Function Today
HTML-код
- Опубликовано: 8 сен 2024
- Excel Calculate Age using Date Function Today video will help you learn how to use Today Date Function in Excel. In this demo, you will learn how to calculate the age of a person using today funtion. You will also learn basic operation order in excel in this video.
Download Excel Practice file here: drive.google.c...
Free Excel Data for Practice: OnlineKnowledg...
This applies to:
Excel 2007 and above
#excelLearningSeries #excel #excel2016 #excelDateFunction #datefunction #calculation
Perfect explanation was so helpful! Thank you very much!! Blessing to you!
Thank you for wonderful words, it truly means a lot. Do subscribe if you haven't already and enable notifications for updates from my channel.
Best Regards,
Syed H | MyKnowledgePortal.com
You made this so easy! Thank you!
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Thanks Syed U have no idea how helpful this was
Thank you for helpful feedback. Do subscribe if you haven't already and enable notifications for updates from my channel.
Best Regards,
Syed H | MyKnowledgePortal.com
you have really answered the name syed. you are worth this name, than for everything. i have been following you for more than 2 weeks now. remain blessed
Thank you for the feedback. I'm truly happy to hear such motivational words. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Thank you very much this is very helpful
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Fantastic, easy to understand
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Thank you teacher
Thanks for ur explanation sir..
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
thanks brother it helps me for setting data
Thank you for your feedback. Do subscribe if you haven't already and enable notifications for updates from my channel.
Best Regards,
Syed H | MyKnowledgePortal.com
Good evening on my side it shows #value!
This is very helpful thank you so much👍🏼👍🏼👍🏼😊
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
@@Syedhussainipage you are doing a great job helping others thanks again
Amazing video!
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
Simply great
Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
thanks you too
I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
I see some issues when the date is before the year 1900
Good vedio sir . Using edate is better I think ..
Thank you for the feedback Página, it helps in keeping me motivated. You may view the eDate function demonstration using this link ruclips.net/video/pXqfjLaiP_s/видео.html
Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
@@Syedhussainipage sorry my mistake I ment datedif not edate ..my mistake
@@paginadefandepes4801 no issues. Check out this link for the demo of datedif function in excel ruclips.net/video/c3fO351KNVs/видео.html
How to calculate age from today excluding weekends ? Could you please help
Hi Sir good evening ☺️ thanks for information, my I know how to compute absent rate ?
Thanks for the explanation, quite straight to the point. Also wish to you help on this, if I want to know an age of hire, with birthdate and hire date available, how different could you assist, please? Say for instance, hire date : 1/6/1995 and birthdate :3/19/1959, will today, as in current date, which way different time line be considered in use?
Sorry for a delayed response. To calculate the age of Hire, always use the Hire Date, however, if calculating the age of a person, you should use Birth Date.
Hope this helps.
Same thing i want from last few years
sorry for very delayed response. Please let me know if you are still looking for any help.
Thanks for the lesson.
How to calculate age in years and months ?
Thank you for your humble words. Here is what I did
=DATEDIF(E2, TODAY(), "Y")&" Years - "&MOD(DATEDIF(E2, TODAY(), "M"), 12)&" Months"
Use this link to download the file. drive.google.com/open?id=1kF555ZNeNP79LCBP0zBUvo_HAUiOtoSv
The function used here is demonstrated in this video ruclips.net/video/c3fO351KNVs/видео.html
Hope you find this helpful.
How we can calculate months and weeks
Syed .
Please can u tell me how can i get age as of today everytime i open excel from date which is already in excel
Try
=(today() - reference-to-cell-with-date-in-excel)/365.25
Today() function always fetches the date of system, hence should do what you need.
Let me know how it goes.
@@Syedhussainipage
Can you please let me extract the age as days , Months and year . And in this approach i am not able to understand the decimal part of the value so please explain it clearly
thanks
arif sarif
Hello! I need help! There isn’t any videos explaining how to calculate Gestational Age? I need to calculate the gestational age in weeks and days on today’s date. How can I do this?
I want to compute based on current date and the age should be in months and ignore formula or no display in age if birthday is blank
sorry for very delayed response. Please let me know if you are still looking for any help.
Syed, follow on question. For my purpose I need to take today’s date and subtract a date and get months. I need the number of months from today a person has been in their position. I tried =(today()-G2)/12. That did not give the correct number of months.
try this ruclips.net/video/c3fO351KNVs/видео.html
If I want the current age, should the whole column on "start date" contain today's date?
For the current Age, the start date can be anything, however, the column where you would be performing calculation needs to use the today's date and remove the start date from it to get to the current age. Hope you find this helpful. In case, I did not answer it as expected, feel free to write back with your inputs and I will assist accordingly.
Best Regards,
Syed H | MyKnowledgePortal.com/
how to calculate retirement date?
I have DOB and the information of total service experience like 5 years 6 months 3 days, i need to know the age of joining can you pls help
Hello Babar,
I see that you want to know the tenure information. Since you have the "experience like 5 years 6 months 3 days" information, you can remove (Subsctract) this from the today() function to get the tenure.
Let me know if you need any help.
Best Regards,
Syed H
how do you set up the calculation to say "N/A" if the date cell is left blank?
YOu may try this =IF(D2="", "", (TODAY()-D2)/365.25) ... basically, we are asking Excel to check if the cell is blank first, and if that is true, set the cell to blank and if not, then do the math. Hope this helps. You may consider watching this: ruclips.net/video/CrmM91TwD0Q/видео.html for clarity on IF Function.
Best Regards,
Syed H | MyKnowledgePortal.com
How to calculate same thing when dob is in format of DD-MM-YY
the format should not be a hurdle. Let me know if you are facing any issue so that I can help accordingly.
Please tell me date with age
Kindly try this along ruclips.net/video/pXqfjLaiP_s/видео.html
Hope you find this helpful.
how to get the age average using excel Sir?
Hello Syed, I use the formula exactly as shown for the date 9-Jul-07 but the answer that populates is shown in 12-Jan-00 format. I've made sure the date formats are the same in both columns I'm working with. Can you help?
You will need to change the format of the cell to Number with two decimals.
Select the result Cell > press "CTRL+1" on keyboard > Select "Number" from left panel in the "Format Cells" window > select your desired number format from right-side panel and click "OK"
Let me know how it goes.
Best Regards,
Syed H
@@Syedhussainipage That sort of worked - I changed the format as you instructed and got a number, but it's a very large one! The date I'm working with in cell D2 is 9-Jul-2007
. I used the formula =(TODAY()-D2/365.25) in cell G2 but got the result of 43879.48
. What did I miss?
Thanks so much for your help!
@@kimholloway3253 you need to enclose the today()-D2 in brackets.
Try this
=(today()-D2)/365.25
The BODMAS rule of math is applied here. Let me know how it goes.
Ah, that was it!! Thanks so much. I really appreciate your help and will be watching more of these!
@@kimholloway3253 Thank you for the feedback. I am so glad to hear that. Do subscribe to my RUclips channel ruclips.net/user/hussainisyed for regular updates.
Best Regards,
Syed H
sir, please how can i extract those employees who's birthday are today into sheet 2
Instead of extracting and creating a new dataset, how about you highlight the row wherever the Birthday appears?
Here is what I did, I applied multiple conditions formatting to highlight any row wherever the month and date is same as of today's date irrespective of year.
Assuming your date is in Column A. You need to use this =AND(MONTH($A1)=MONTH(TODAY()), DAY($A1)=DAY(TODAY()))
You may watch this episode for more help on how to do this:
ruclips.net/video/b2QtnibRTdA/видео.html
Once you have the rows highlighted, you may filter based on color and extract the data easily.
Link of the file (Download it to your PC before opening) where I did this: drive.google.com/open?id=1O1HsJGy9GSSBDqctlfU1Yh9NtRHTkaOB
Hope you find this helpful.
Best Regards,
Syed H | MyKnowledgePortal.com
I am still getting the date insted of age can you hep me???
Did you check the format of the cell?
Let me know if changing the format helps; if not, please share the sample sheet and I can help.
It doesn't work whenever I applied this formula on it 27-12-1998 to 15-06-2020 its says the answer is 21-01-1900 I'm really hopeless can you please correct me? I'm waiting for you.
You will need to change the format of the cell to Number with two decimals. Select the result Cell > press "CTRL+1" on keyboard > Select "Number" from left panel in the "Format Cells" window > select your desired number format from right-side panel and click "OK".
Also you need to enclose the today()-D2 in brackets.
Try this
=(today()-D2)/365.25
The BODMAS rule of math is applied here. Let me know how it goes.
Hope this helps.
My excel doesn't function this way of calculating ages, I do not know why.
Let us catch up over a brief call and I can check what's wrong. Book me for tomorrow using meet.zaha.in
But how do I round down the age ..so that it appears as a figure like 34 not 34.91
You can do that by decreasing the number of the decimal places. See this image drive.google.com/file/d/1s5sJt6nuiEZ1WJ13Pz43w7ApPxVE0QJD/view?usp=sharing for help.
Do subscribe if you haven't already and enable notifications for updates from my channel.
Best Regards,
Syed H | MyKnowledgePortal.com
@@Syedhussainipage This is fine and works very well if all that you want is the persons age in decimal format. It gets a bit more complicated and can be a bit misleading if a person is approaching their birthday and if you choose to round down to a whole number. For example; if someone is born on 24/03/1956 and you calculate their age from today 11/03/2020 the formula would give an age of 63.96 which is correct mathematically. But if you round this to a whole number it would read 64 whereas the person is still 63 as of today's date. My point is that this works great but you need to understand what you are looking at and how the formula works.
Great video though and a very thorough explanation.
I have used this exactly but I get a date instead of numbers
sorry for very delayed response. Please let me know if you are still looking for any help.
i tried it and it gave me different date, how can i fix this ?
sorry for very delayed response. Please let me know if you are still looking for any help.
It should have been more shortcut and clear
Thank you for the feedback, it is truly helpful.
Best Regards,
Syed H
I tried the way you showed but did not get the age.
Could you please tell me what went wrong
Hello sir….i want to calculate employee tenure. I know how to calculate when we have start & end date. But when END DATE is not available it should automatically calculate the tenure by taking current date. Pls help me…
Hello Sachin,
You may watch this video ruclips.net/video/JFmat61Qjok/видео.html that will help you get what you want.
Let me know how it goes.
Best Regards,
Syed H
I used the dates 9/10/2019 and 24/6/1981. I get the value #VALUE!. PLEASE SOLVE THIS PROBLEM.
How are you using it? I used it as follows:
First put these values in cells
A2 = 09/Oct/2019
B2 = 24/Jun/1981
Now in Cell C2 use the following:
C2 = (A2-B2)/365.25 = 38.29
.25 is for leap year.
if you do it the other way i.e. B2-A2, you will get a negative value.
Please check and let me know.
Best Regards,
Syed H | MyKnowledgePortal.com
2nd Jan 1979 to 30th June 2011
Age Is about 32 years....
79-89 = 10 y
89-99 = 20 y
99-09 = 30y
09-11 = 32y
Excel option might be wrong........
Excel shows 32.49 as the output which is right. What did you get in your answer?
I am using "(B1-A1)/365.25" where B1 = 30 June 2011 and A1 = 2 Jan 1979.
Respond to this thread with your inputs.
Best Regards,
Syed H
@@Syedhussainipage
Sir watch the video once again @3:40 time
Your formula is
(Today()-D2)/365.25)
Excel output is 38.91 years
But real scenario is 32+ years of age
Just check sir.... You didn't used the formula (B1-A1)/365.25
@@sksiva8740 I am using today function because I am calculating the current age. The scenario you mentioned has a specified start and end date where your end date is not current date which is why we have used references of a1 and b1.
Hope this helps.
Best Regards,
Syed H
And I could see that you are picking up the start date shown in the column E.
Please note that it is a start date of an employee in the organisation and we are not considering that to calculate the age.
The start date under the column E is exclusively used to calculate the tenure of the employees in the organisation.
Hope you find this helpful.
Best Regards,
Syed H
NOOOO.. THIS IS JUGGAAAR...NOT PROPER CALCULATIONS....=DATEDIF(????) SYNTAX IS VALID FOR EACH YEAR , MONTH AND DAY......
Are you Indian 🤔.
Yes, I am