calculate age

  • Thread starter Thread starter CrashMatRob
  • Start date Start date
C

CrashMatRob

I know you can calculate your age in days by
date born A1= 30/09/1978
and B1= today()
= A1-B1

but can I calculate days and time born - today's date and time?
date born A1= 30/09/1972 16:20
and B1= now()

To find the result number of days and hours

Thanks
Rob
www.CrashMatRob.com
 
Yes, of course you can - just apply a custom format to the cell to
display days and time. Note, though, that NOW() changes more often
than TODAY() - everytime you recalculate the sheet the value will be
updated. You will also have to subtract the birthdate and time away
from NOW, i.e. =B1-A1.

Hope this helps.

Pete
 
=FLOOR(B1-A1,1)&" days, "&TEXT(MOD(B1-A1,1),"hh:mm:ss")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top