Should be 13th March 2012

This formula will do it. If you add your time of birth it will be more
accurate. (I also presume you are calling 1 billion, one-thousand million,
not one million, million, or you would be a lot older!

=DATE(1980,7,5)+(((1000000000/60)/60)/24)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"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!