calculate age

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CrashMatRob - 30 Jul 2008 17:07 GMT

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

Reply to this Message

Pete_UK - 30 Jul 2008 17:15 GMT

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

> I know you can calculate your age in days by
> date born A1= 30/09/1978
[quoted text clipped - 9 lines]
> Thanks
> Robwww.CrashMatRob.com

Reply to this Message

Bob Phillips - 30 Jul 2008 17:20 GMT

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

Signature

HTH

Bob

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

> I know you can calculate your age in days by
> date born A1= 30/09/1978
[quoted text clipped - 10 lines]
> Rob
> www.CrashMatRob.com

Reply to this Message

CrashMatRob - 31 Jul 2008 16:25 GMT

Thanks for the help,

I found Mr. Bob Phillips formula did what I was looking for.

Thanks again
Rob
www.CrashMatRob.com

rob.marshall@ntlworld.com

Reply to this Message