(Msg. 2) Posted: Thu Sep 04, 2008 10:56 am
Post subject: RE: age [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
if age is in cell a1...
=(NOW()-A1)/365.25
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown
"pavlos" wrote:
> Please give formula for age from Date of Birth i.e.
> what is the age of:
> 14-Dec-54
> 12-Σεπ-57
>
(Msg. 3) Posted: Thu Sep 04, 2008 10:57 am
Post subject: RE: age [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=DATEDIF(A1,TODAY(),"y")
"pavlos" wrote:
> Please give formula for age from Date of Birth i.e.
> what is the age of:
> 14-Dec-54
> 12-Σεπ-57
>
(Msg. 4) Posted: Thu Sep 04, 2008 7:01 pm
Post subject: Re: age [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
With 14-Dec-54 in A1 use:
=DATEDIF(A1,TODAY(),"y")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2.TakeThisOut@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
"pavlos" <pavlos.TakeThisOut@discussions.microsoft.com> wrote in message
news:A5741785-C2EB-4B3D-BD42-313D13F1D04C@microsoft.com...
> Please give formula for age from Date of Birth i.e.
> what is the age of:
> 14-Dec-54
> 12-???-57
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office