How old is excel




















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. To make your age formula more flexible, you can input the date in some cell and reference that cell in your formula:.

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:.

Because the exact date of the medical examination is not defined, you use the DATE function with an arbitrary date and month argument, e. DATE C3, 1, 1. As the result, you get the patient's age as of January 1 of a particular year:. Supposing your friend was born on 8 March 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. 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 :.

When a birthdate is split into 3 different cells e. If you'd rather not reinvent the wheel, you can use the age calculator created by our Excel professionals.

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. 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:B Download Age Calculator for Excel.

The users of our Ultimate Suite don't have to bother about making their own age calculator in Excel - it is only a couple of clicks away:. 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".

You can spend some time practicing almost anything you want to learn, from large spreadsheets to logic functions and conditional formulas. The choice is yours, and you have the freedom to complete each module at your own pace. This is a relatively new learning kit, but more than people have already signed up. You can join them and learn more via the widget below. Table of Contents. Expand your skills.

Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen.



0コメント

  • 1000 / 1000