You still have a few years to go!

A1 = 7/5/1980

=INT(A1+1E9/86400)

Format as date

If you want to know to the second then you'd have to enter the time of birth
in A1:

A1 = 7/5/1980 4:33 AM (I don't know if they record the seconds on a birth
certificate)

=A1+1E9/86400

Format as m/d/yyyy h:mm:ss AM/PM


--
Biff
Microsoft Excel MVP


"sross002" wrote in message
...
Hello, if someone can please help me with this, I would truly appreciate
it.
Is there a way in Excel to compute the following question:
I would like to find out at what point in my life I lived 1 billion
seconds.
I have to consider leap years as well. My birthday is July 5th, 1980.

Basically, I guess all I need to do is convert 1 billion seconds into
days.

Please help!