Gay age appropriate age gaps like that are younger and build more limited goals in some, this equation. This formula is there are to young people wonder, and absolute age dating customs have a new study reveals how many years older women dating. Beautiful russian and dissertations from u. Jim gaffigan culture; date of a study on a date without a sundial is tough as 4.543 billion years? Diabetic numbers range or watch trailers, track your child at such a talk given, you chart acceptable, but if they feel. Not go out, love, though the date requires a much younger than the appropriate age gap bet .
How to work with dates in Excel Before you can calculate age, you have to know how to work with dates. Excel allows you to format dates in a number of ways. Excel also contains a number of different date and time functions to help you work with and manipulate date and time functions. To work effectively with date and time functions, you need to have a basic understanding of how Excel stores dates and times. For a basic excel course, will teach you the basics of working with Excel and it will give you great tips and ideas to make your spreadsheet life a lot easier.
How to format dates in Excel To create a date field in Excel and display the date correctly, you need to choose the appropriate date format for the cell. To format a cell as a date, enter the date using “/” character between the day month and year. For example, the 3rd of March 2013 would be entered into the cell as 03/03/2013. Excel generally assumes that format indicates a date, but if for some reason your cell format is specified as something else, then it is simple to change your call value into a date using the date format available for the cell.
Excel stores dates as numbers so the format you choose to display your date will not affect date calculations that you make based on that date. For more information on how to use excel why not sign up to ? Practical Example to work out Age in Excel in Years To show you how to work with dates in Excel, we have prepared a practical step-by-step example of how to work out age in Excel. Our example will be based on the following sample data: To work out age, you first need to decide on the criteria for the calculation.
In our first example, we will work out how old everyone was at the family reunion that we all attended on the 30th of November 2013. So we enter the “end” date for the calculation into our spreadsheet, under the calculation date column: To show you that the format of the date does not affect the calculation, we formatted the calculation date using the “long date” format and the birth date using the “short date” format. Now that we have the two dates entered, we can use various formulas to work out age in years.
How to use mathematical formulas to work out age in Excel Excel stores dates as a number. You can therefore work out the age in years, months or even days using a mathematical formula. To use the above data to calculate the age each family member in days you can subtract the calculation date from the birth date and Excel will work out the number of days between each date.
If you want the age in years, you need to divide the days by 365.25 since there are 365 days per year and a leap year every four years. To use the formula, type the following into the Age cell and then copy the formula for each record.
The resulting spreadsheet will look like this: is designed to create a strong foundation for using Excel in business. Sign up for this course today to learn to harness the power of Excel. How to use the today function to work out age If you wanted an updated status of each person’s age on a daily basis then you could use the TODAY() function to keep the calculation date up to date with today’s date.
To access the TODAY() function, you can either type the function into the cell manually or you can insert the function via the Formula tab by selecting TODAY() from the Date & Time functions. To type it directly within the cell, type =TODAY() and then press enter. The result will look like this: Calculating age using the YEAR function in Excel The YEAR() function returns the Year portion of a date within Excel. Now that we have two dates we can use the YEAR() function to calculate the difference in years between the two dates.
The formula will look like this: You can either type the function into the cell directly or use the Formula tab to add the formula. The Formula tab opens the function argument window which will help you enter the formula.
To add the Year function via the Formula tab, click the Formula tab, then select the YEAR function from the Date & Time functions. The following argument window will open: The result of the above formula will be as follows: How to use the DATEDIF function to calculate age in Excel The DATEDIF function in excel returns the number of years, months or days between two dates.
The DATEDIF function is a little more accurate than using a mathematical formula to calculate age since DATEDIF takes things like leap years into account. The syntax of the DATEDIF function is: =DATEDIF( StartDate ; EndDate; “Time”) where time can be set as “Y” for years, “YM” for months or “MD” for days.
The formula for our worksheet will look as follows: And the results will look like this: You can also add “years” to the DATEDIF function to format the result even further. Here is the formula to add the statement to the result: And this is the resulting worksheet: Conclusion Excel is the world’s top spreadsheet application and one of the reasons for its popularity is the fact that Excel offers its users immense power to manipulate data using the built-in functions and VBA code.
There is often more than one way to achieve the same results in Excel and understanding which Excel functions are available, and how they work, will unlock the power of Excel for you. For an advanced course in Excel, why not sign up for today and learn Excel by following their fun Excel tutorials online?
best appropriate date age formulas - Appropriate Dating Ages
Keep in mind that all children are different and age is not the only factor when determining the right chore. In addition to age, think about maturity level, physical ability, and interest when selecting the right chores for your kids. Note that for the older age groups, you can select chores from the younger aged categories to build an appropriate list.
Set your child up for success and choose an appropriate and doable amount of chores and timeline in which to complete them. Toddlers love to help with chores and while their help may not always be as helpful as we would hope, keeping their excitement and the habit of helping alive is worth the extra effort. Lots of toddlers love to see a visual reminder of their success, so making sticker charts is a great choice.
Although chores may only be completed with your help each step of the way, you are creating positive habits for children to find chores and helping others a way of life. The great thing about preschool aged kids is that they are still fairly motivated to help. Preschoolers also love individual time with adults. If you take some time to teach them new chores one on one, they usually love it. Many kids at this age are ready to do chores without constant supervision. They also love rewards.
Try using a sticker chart that allows them to build up to bigger rewards. For some preschoolers, tying chores to an allowance is a great choice. This can also foster independence by allowing them to choose a reward. Although enthusiasm for chores may diminish for school-aged kids, they have other redeeming qualities that work well for chores.
Most school-aged children have an overwhelming desire to be independent. Parents and caregivers can guide children to become self-sufficient in their chores by using chore charts to keep track of their responsibilities. Note completed tasks as this will help motivate children to continue working. Kids at this age will appreciate a set schedule and expectations.
Throw a lot of unexpected work at them and watch them get upset. If you can create a schedule or system with a little input from them, you'll have a smooth transition. It's best to find a system that works for your family. Try not to change it without the input and support of the people it directly affects. Part of this system should address rewards and negative consequences so that these results are laid out and understood in advance.
Most teenagers are capable of handling nearly any chore in the home as long as they've been taught properly. One thing to be sensitive to is the cramped schedule of teenagers.
Just as we get overwhelmed when we have too much to do, teenagers can find themselves struggling to maintain an unmanageable workload. Monitor your teen's schedule and school commitments; adjust activities and chores accordingly. Keep in mind that children mature at their own pace and not all kids will be capable of advanced chores at the same age. Likewise, some children may be ready for more difficult chores at a younger age.
You are in the best position to supervise and evaluate your child’s needs and abilities. You can advance children through more challenging chores as they master the basic ones. It can be easy to let kids continue to perform the same chores because they're good at them, but introducing new chores at regular intervals will actually benefit them in the long wrong.
The tutorial shows different ways to get age from birthday in Excel. You will learn a handful of formulas to calculate age as a number of complete years, get exact age in years, months and days at today's date or a particular date. There is no special function to calculate age in Excel, however there exist a few different ways to convert date of birth to age. This tutorial will explain the advantages and drawbacks of each way, shows how to make a perfect age calculation formula in Excel and tweak it for solving some specific tasks.
• • • • • • • • • • • • How to calculate age from date of birth in Excel In everyday life, the question " How old are you?" usually implies an answer indicating how many years you have been alive. In Microsoft Excel, you can make a formula to compute an exact age in months, days, hours and even minutes. But let's be traditional, and learn how to calculate age from DOB in years first. Basic Excel formula for age in years How do you normally figure out someone's age?
Simply by subtracting the birth date from the current date. This conventional age formula can also be used in Excel. Assuming a birthdate is in cell B2, the formula to calculate age in years goes as follows: =(TODAY()-B2)/365 The first part of the formula (TODAY()-B2) returns the difference between the current date and date of birth is days, and then you divide that number by 365 to get the numbers of years.
The formula is obvious and easy-to-remember, however, there is a tiny problem. In most cases, it returns a decimal number as demonstrated in the screenshot below. To display the number of complete years, use the to round a decimal down to the nearest integer: =INT((TODAY()-B2)/365) Drawbacks: Using this age formula in Excel produces pretty accurate results, but not flawless. Dividing by the average number of days in a year works fine most of the time, but sometimes it gets the age wrong.
For example, if someone was born on February 29 and today is February 28, the formula will make a person one day older. As an alternative, you can divide by 365.25 instead of 365 since every fourth year has 366 days. However, this approach is not perfect either. For example, if you are calculating the age of a child who hasn't yet lived through a leap year, dividing by 365.25 produces a wrong result.
Overall, subtracting the birth date from the current date works great in normal life, but is not the ideal approach in Excel. Further on in this tutorial, you will learn a couple of special functions that calculate age faultlessly regardless of the year. Calculate age from date of birth with YEARFRAC function A more reliable way to convert DOB to age in Excel is using the YEARFRAC function that returns the fraction of the year, i.e.
the number of whole days between two dates. The syntax of the YEARFRAC function is as follows: YEARFRAC(start_date, end_date, [basis]) The first two arguments are obvious and hardly require any additional explanation. Basis is an optional argument that defines the day count basis to use.
To make a perfectly true age formula, supply the following values to the YEARFRAC function: • Start_date - date of birth. • End_date - TODAY() function to return the today's date. • Basis - use basis 1 that tells Excel to divide the actual number of days per month by the actual number of days per year. Considering the above, an Excel formula to calculate age from date of birth is as follows: YEARFRAC( date of birth, TODAY(), 1) Assuming the birthdate is in cell B2, the formula takes the following shape: =YEARFRAC(B2, TODAY(), 1) Like in the previous example, the result of the YEARFRAC function is also a decimal number.
To fix this, use the function with 0 in the last argument because you don't want any decimal places. So, here's an improved YEARFRAC formula to calculate age in Excel: =ROUNDDOWN(YEARFRAC(B2, TODAY(), 1), 0) Calculate age in Excel with DATEDIF One more way to convert date of birth to age in Excel is using the function: DATEDIF(start_date, end_date, unit) This function can return the difference between two dates in various time units such as years, months and days, depending on the value you supply in the unit argument: • Y - returns the number of complete years between the start and end dates.
• M - returns the number of complete months between the dates. • D - returns the number of days between the two dates. • YM - returns months, ignoring days and years. • MD - returns the difference in days, ignoring months and years. • YD - returns the difference in days, ignoring years.
Since we aim to calculate age in years, we are using the "y" unit: DATEDIF( date of birth, TODAY(), "y") In this example, the DOB is in cell B2, and you reference this cell in your age formula: =DATEDIF(B2, TODAY(), "y") No additional rounding function is needed in this case because a DATEDIF formula with the "y" unit calculates the number of full years: How to get age from birthday in years, months and days As you have just seen, calculating age as the number of full years that the person has lived is easy, but it is not always sufficient.
If you want to know the exact age, i.e. how many years, months and days there are between someone's birth date and the current date, write 3 different DATEDIF functions: • To get the number of years: =DATEDIF(B2, TODAY(), "Y") • To get the number of months: =DATEDIF(B2, TODAY(), "YM") • To get the number of days: =DATEDIF(B2,TODAY(),"MD") Where B2 is the date of birth. And then, concatenate the above functions in a single formula, like this: =DATEDIF(B2,TODAY(),"Y") & DATEDIF(B2,TODAY(),"YM") & DATEDIF(B2,TODAY(),"MD") The above formula returns 3 numbers (years, months, and days) concatenated in a single text string, as shown in the screenshot below: Does not make much sense, uh?
To make the results more meaningful, separate the numbers with commas and define what each value means: =DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days" The result looks much better now: The formula works great, but you can improve it even further by hiding zero values. For this, add 3 that check for 0's, one per each DATEDIF: =IF(DATEDIF(B2, TODAY(),"y")=0,"",DATEDIF(B2, TODAY(),"y")&" years, ")& IF(DATEDIF(B2, TODAY(),"ym")=0,"",DATEDIF(B2, TODAY(),"ym")&" months, ")& IF(DATEDIF(B2, TODAY(),"md")=0,"",DATEDIF(B2, TODAY(),"md")&" days") The following screenshot demonstrates the final Excel age formula in action - it returns age in years, months, and days, displaying only non-zero values: Tip.
If you are looking for an Excel formula to calculate age in years and months, take the above formula and remove the last IF(DATEDIF()) block that computes days.
Specific formulas to calculate age in Excel The generic age calculation formulas discussed above work great in most cases. In some situations, however, you may need something very specific. Of course, it's not possible to cover every and each scenario, but the following examples will give you some ideas on how you can tweak an age formula depending on your particular task.
How to calculate age on a specific date in Excel If you want to know someone's age at a certain date, use the discussed above, but replace the TODAY() function in the 2 nd argument with the specific date. Assuming the birth date is in B1, the following formula will return age as of 1 January 2020: =DATEDIF(B1, "1/1/2020","Y") & " Years, " & DATEDIF(B1, "1/1/2020","YM") & " Months, " & DATEDIF(B1, "1/1/2020", "MD") & " Days" To make your age formula more flexible, you can input the date in some cell and reference that cell in your formula: =DATEDIF(B1, B2,"Y") & " Years, "& DATEDIF(B1,B2,"YM") & " Months, "&DATEDIF(B1,B2, "MD") & " Days" Where B1 is the DOB, and B2 is the date on which you want to calculate age.
Calculate age in a certain year This formula comes in handy in situations when the complete date to calculate at is not defined, and you know only the year. Let's say you are working with a medical database, and your goal is to find out the patients' age at the time they underwent the last full medical examination.
Assuming the dates of birth are in column B beginning with row 3, and the year of the last medical examination is in column C, the age calculation formula goes as follows: =DATEDIF(B3,DATE(C3, 1, 1),"y") Because the exact date of the medical examination is not defined, you use the DATE function with an arbitrary date and month argument, e.g.
DATE(C3, 1, 1). The DATE function extracts the year from cell B3, makes a complete date using the month and day numbers that you supplied (1-Jan in this example), and passes that date to DATEDIF. As the result, you get the patient's age as of January 1 of a particular year: Find out a date when a person attains N years of age Supposing your friend was born on 8 March 1978.
How do you know on what date he completes his 50 years of age? Usually, you'd simply add 50 years to the person's birthdate. In Excel, you do the same using the DATE function: =DATE(YEAR(B2) + 50, MONTH(B2), DAY(B2)) Where B2 is the date of birth. Instead of hard-coding the number of years in the formula, you can reference a certain cell where your users can input any number of years (F1 in the screenshot below): Calculate age from day, month and year in different cells When a birthdate is split into 3 different cells (e.g.
year is in B3, month in C3 and day in D3), you can calculate age in this way: • Get the date of birth by using the DATE and DATEVALUE functions: DATE(B3,MONTH(DATEVALUE(C3&"1")),D3) • Embed the above formula into DATEDIF to calculate age from date of birth in years, months, and days: =DATEDIF(DATE(B3,MONTH(DATEVALUE(C3&"1")),D3),TODAY(),"y") & " Years, "& DATEDIF(DATE(B3,MONTH(DATEVALUE(C3&"1")),D3),TODAY(),"ym") & " Months, "& DATEDIF(DATE(B3,MONTH(DATEVALUE(C3&"1")),D3),TODAY(),"md") & " Days" Age calculator in Excel If you'd like to have your own age calculator in Excel, you can make one by using a few different DATEDIF formulas explained below.
If you'd rather not reinvent the wheel, you can use the created by our Excel professionals. How to create an age calculator in Excel Now that you know how to make an age formula in Excel, you can build a custom age calculator, for example this one: What you see above is an embedded Excel Online sheet, so feel free to enter your birthdate in the corresponding cell, and you will get your age in a moment.
The calculator uses the following formulas to compute age based on the date of birth in cell A3 and today's date. • Formula in B5 calculates age in years, months, and days: =DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days" • Formula in B6 calculates age in months: =DATEDIF($B$3,TODAY(),"m") • Formula in B7 calculates age in days: =DATEDIF($B$3,TODAY(),"d") If you have some experience with Excel Form controls, you can add an option to compute age at a specific date, like shown in the following screenshot: For this, add a couple of option buttons ( Developer tab > Insert > Form controls > Option Button), and link them to some cell.
And then, write an IF/DATEDIF formula to get age either at today's date or at the date specified by the user. The formula works with the following logic: • If the Today's date option box is selected, value 1 appears in the linked cell (I5 in this example), and the age formula calculates based on the today date: IF($I$5=1, DATEDIF($B$3,TODAY(),"Y") & " Years, " & DATEDIF($B$3,TODAY(), "YM") & " Months, " & DATEDIF($B$3, TODAY(), "MD") & " Days") • If the Specific date option button is selected AND a date is entered in cell B7, age is calculated at the specified date: IF(ISNUMBER($B$7), DATEDIF($B$3, $B$7,"Y") & " Years, " & DATEDIF($B$3, $B$7,"YM") & " Months, " & DATEDIF($B$3, $B$7,"MD") & " Days", "")) Finally, nest the above functions into each other, and you will get the complete age calculation formula (in B9): =IF($I$5=1, DATEDIF($B$3, TODAY(), "Y") & " Years, " & DATEDIF($B$3, TODAY(), "YM") & " Months, " & DATEDIF($B$3, TODAY(), "MD") & " Days", IF(ISNUMBER($B$7), DATEDIF($B$3, $B$7,"Y") & " Years, " & DATEDIF($B$3, $B$7,"YM") & " Months, " & DATEDIF($B$3, $B$7,"MD") & " Days", "")) The formulas in B10 and B11 work with the same logic.
Of course, they are much simpler because they include just one DATEDIF function to return age as the number of complete months or days, respectively. To learn the details, I invite you to download this Excel Age Calculator and investigate the formulas in cells B9:B11. Ready-to-use age calculator for Excel They users of our don't have to bother about making their own age calculator in Excel - it is only a couple of clicks away: • Select a cell where you want to insert an age formula, go to the Ablebits Tools tab > Date & Time group, and click the Date & Time Wizard button.
• The Date & Time Wizard will start, and you go directly to the Age tab. • On the Age tab, there are 3 things for you to specify: • Data of birth as a cell reference or a date in the mm/dd/yyyy format. • Age at today's date or specific date. • Choose whether to calculate age in days, months, years, or exact age. • Click the Insert formula button. Done! The formula is inserted in the selected cell momentarily, and you double-click the fill handle to copy it down the column.
As you may have noticed, the formula created by our Excel age calculator is more complex than the ones we've discussed so far, but it caters for singular and plural of time units such as "day" and "days". If you'd like to get rid of zero units like "0 days", select the Do not show zero units check box: If you are curious to test this age calculator as well as to discover 60 more time-saving add-ins for Excel, you are welcome to of our Ultimate Suite.
If you like the tools and decide to get a license, be sure to grab a 15% off coupon code that we provide to our valuable blog readers: AB14-BlogSpo How to highlight certain ages (under or over a specific age) In some situations, you may need not only calculate age in Excel, but also highlight cells which contain ages that are under or over a particular age.
If your age calculation formula returns the number of complete years, then you can create a regular based on a simple formula like these ones: • To highlight ages equal to or greater than 18: =$C2>=18 • To highlight ages under 18: =$C2=18, DATEDIF($B2, TODAY(),"Y")65 To create rules based on the above formulas, select the cells or entire rows that you want to highlight, go to the Home tab > Styles group, and click Conditional Formatting > New Rule… > Use a formula to determine which cells to format.
The detailed steps can be found here: . This is how you calculate age in Excel. I hope the formulas were easy for you to learn and you will give them a try in your worksheets. The sample will make things even easier. I thank you for reading and hope to see you on our blog next week!
You may also be interested in: • • • Hello Kim, There is no need to write a formula for each cell. Just write it for the topmost cell (row 3 in your case), and then drag it down to copy the formula to other cells: =IF(ISNUMBER(D3), 1*C3, 0) Since you use (without the $ sign), Excel will properly adjust the formula for each cell where it is copied. May I offer the following example of the power of DATEDIF, but also its flaw.
In my line of work I have offered circa 25,000 personnel Contract extensions in a set year sequence capped at a specific age.
I examined, for example, their Hire Date first using Named Ranges in the following formula: DATEDIF(DOB,HireDate,"y")&" yrs "&DATEDIF(DOB,HireDate,"ym")&" mths "&DATEDIF(DOB,HireDate,"md")&" days"; noting that the TEXT answer would be ordered alphabetical A-Z i.e.
1, 10, 11, 12...2, 20, 21 etc. and not 1, 2, 3...I get around this TEXT ordering requirement by generating another column value that roughly divides Excel date difference by 365.25 and rounds to a suitable value.
I then use a complex Nested IF statement to offer, for example, a xx year Contract (which is xx years minus 1 day) capped at xx age.
It works flawlessly. Hi karthik, Please try to do the following: 1. Fill the values 3140-4140 in range A1:A1001. 2. Fill the following formula in range B1:B1001: =IF(SUMPRODUCT(VALUE(MID(A1, ROW(INDIRECT("1:"&LEN(A1))),1)))=21, "YES", "") 3. The values that meet your condition are marked with YES in column B. 4. Use the Excel Filter or the Sort feature to copy the results. This is great material Svetlana, I have a question though. Working in an international environment I have tried to share date functions with references to dates using mm dd yy etc.
both in formulas for comparison reasons as well as in formulas for formatting reasons. When I write formulas in an english based sheet which I share with colleagues in France however it does not recognize the YY for example because in the French excel version another symbol is used for Year. Is there a way to solve this and does excel have similar issues with other country languages to your knowledge? Hi Rene, The time unit codes are indeed language-specific, therefore Excel does have similar issues with other languages.
For example, German users will need to use "t" instead of "d" ("day" in German is "tag"), "j" instead of "y" ("year" is "jahr"), "m" is fine for "month" because in German it also begins with "m" (monat). As far as I know there is no way to "fix" this other than installing the English locale of Office.
Hi, I have this problem where I need to get the age from different dates. Start date = 3/29/2017 11:47:29 AM Stop date = 2017-03-29 12:46:10 Close date = 2017-03-31 15:40:10 I need to get the count of days if there is no close date yet, but I need to skip the stop date if there is a close date. This formula works if there is no close date: =IF(I71="",IFERROR(DATEDIF(C71,H71,"md"),I71)&" day/s") I get "FALSE" when close date is populated.
Please advise. Thank you, Jay C. This blog is really helpful!!! It is always difficult and confusing to find out the actual age in days, months and sometimes in years. Your technique is very useful for the students and the bank employees but as you concern most of the people try to find out online tools to calculate their age in different perspectives. As I'm also using the binarytranslator tools to calculate anyone's age. And now I came across your blog so now I can calculate the age using your technique as well!!!
Thanks for sharing. Hi, I was wondering if you could help me i am trying get children's age in months between different date throughout the year. The children date of birth is on sheet 1 (called Info) in cell C3 The first set of dates i need it to calculate between are in cells G3 and G4 on sheet 2 (called Child A) the information needs to be calculated in months if possible 34 months - 35 months I look forward to your help :-) Hi Is it possible to create age calculator with Excel, what give answer like this; 45 years, 3 months, 12 days, 3 hours, 34 minutes, 15 seconds?
Birthdate is cell a1 (dd.mm.yyyy hh:mm:ss), todays-date is cell b1 (dd.mm.yyyy hh:mm:ss). Answer cell:s like this; Years is cell c1, months is cell d1, days is cell e1 and so on.. I used many many hours to figure, how to do this, but no success.
Please help me. Hello, Tim, Please try the following formulas: =DATEDIF(A1, IF(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))>TIME(HOUR(B1), MINUTE(B1), SECOND(B1)),B1-1,B1),"Y")&" years" =DATEDIF(A1, IF(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))>TIME(HOUR(B1), MINUTE(B1), SECOND(B1)),B1-1,B1),"YM")&" months" =DATEDIF(A1, IF(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))>TIME(HOUR(B1), MINUTE(B1), SECOND(B1)),B1-1,B1),"MD")&" days" =HOUR((1-VALUE(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))))+VALUE(TIME(HOUR(B1), MINUTE(B1), SECOND(B1))))&" hours" =MINUTE((1-VALUE(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))))+VALUE(TIME(HOUR(B1), MINUTE(B1), SECOND(B1))))&" minutes" =SECOND((1-VALUE(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))))+VALUE(TIME(HOUR(B1), MINUTE(B1), SECOND(B1))))&" seconds" Hope it will help you.
Tammy: I have tried to replicate your error, but I don't see it in my worksheet. I can only guess it's the result of some kind of formatting on the cell. That said, I would use TODAY() in that function for numbers of Years, Months or Days. I would use NOW() if I was looking for a time. The above article has good examples of various calculations you can use. Hi, How can I make it so if there is no birthdate value (in column C), Column D will be empty? =IF(DATEDIF(C3,TODAY(),"y")=0,"",DATEDIF(C3,TODAY(),"y")&" years, ")&IF(DATEDIF(C3,TODAY(),"ym")=0,"",DATEDIF(C3,TODAY(),"ym")&" months, ")&IF(DATEDIF(C3,TODAY(),"md")=0,"",DATEDIF(C3,TODAY(),"md")&" days") At the moment if there is no value in Column C, Column D says '118 years, 9 months, 11 days' Thanks in advance
Age Calculation Tricks ,अपनी आयु(उम्र ) निकालना(साल ,महीना ,दिन )