Dating age formula wikipedia 2016 dating website in eu
One use for Excel's DATEDIF function is to calculate a person's current age.If you don't feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue.The oldest rocks which have been found so far (on the Earth) date to about 3.8 to 3.9 billion years ago (by several radiometric dating methods).Some of these rocks are sedimentary, and include minerals which are themselves as old as 4.1 to 4.2 billion years.
To make the formula easier to work with, a person's birth date is entered into cell E1 of a worksheet (see the example below).
Since the TODAY() function uses the computer's serial date to find the current date, the function continually updates every time a worksheet is recalculated.
he generally accepted age for the Earth and the rest of the solar system is about 4.55 billion years (plus or minus about 1%).
The ampersand ( & ) is a concatenation symbol in Excel.
One use for concatenation is to join number data and text data together when used in a single formula.