# born

1. ### Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

Hi all, Within my Family Tree I work out the exact age of an individual using the following formula, E19 is date of birth and E20 is date of death. =DATEDIF(E19,E20,"y") & " years, " & DATEDIF(E19,E20,"ym") & " months, " & DATEDIF(E19,E20,"md") & " days" I have just come across a problem with...
2. ### Anyone have a good solution to this problem?

Hi I have a table of 16087 rows and 7 columns. and im strugling with similer names in column A and Vlookup that picks the first hit. This is a dogbreed that have dogs with simple names and i want to pick right father/mother combinations based on age and probability to puppies. Now i have these...
3. ### Date to age question

Hi all I am working on my family tree and thought I would create a spreadsheet that automatically updates the ages of all protagonists when the user opens the document. I have managed to achieve this successfully using the following formula: =INT((H2-A2)/365) The only issue I have is...
4. ### Input an ID number, find it among 65 ranges, obtain birth year

Hello everyone, thanks in advance for your time. I've got this problem: 1. I have a list of almost 24K ID numbers. 2. I have a table with ranges, saying: "from ID #1.000.000 to ID #2.000.000 was born in 1920"; and so with another 65 ranges, saying from this ID to that ID was born in this...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back