Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Age calculation

3 views
Skip to first unread message

Araxes Tharsis

unread,
Jan 20, 1999, 3:00:00 AM1/20/99
to
This is an old problem: how do I calculate the age of one person EXACTLY
in Excel 97?
In previous versions of Excel, there was an undocumented function DATEDIF
that did the trick, but apprarently it doesn't work in Excel 97...
Can anyone help?
Please mail-me: ATHA...@MAIL.TELEPAC.PT

Eddie Griffiths

unread,
Jan 20, 1999, 3:00:00 AM1/20/99
to
Ah shit, don't tell me microsoft have removed it!!!!!!!

--
Eddie Griffiths
Invercargill
New Zealand

E-Mail: edg...@clear.net.nz
Homepage: http://www.geocities.com/MotorCity/Garage/7286/
ICQ-Page Address: http://wwp.mirabilis.com/10486128
ICQ# 10486128

Araxes Tharsis wrote in message <78372h$108$1...@duke.telepac.pt>...

Aidan

unread,
Jan 24, 1999, 3:00:00 AM1/24/99
to
I think you will find that the Analysis ToolPak will help - make sure it is
added (tools addins - unless they've moved it since Excel 95!!) - DateDiff
(I think) was a function within this. IF it has gone, YEARFRAC is still
there - if you use INT(YEARFRAC(day1,day2)) you will get the whole number
result you want... if you want the days and months etc, remove the INT part!
Eddie Griffiths wrote in message ...

Myrna Larson

unread,
Jan 24, 1999, 3:00:00 AM1/24/99
to
On Sun, 24 Jan 1999 09:43:37 -0000, "Aidan" <aidan.h...@virgin.net> wrote:

>I think you will find that the Analysis ToolPak will help - make sure it is
>added (tools addins - unless they've moved it since Excel 95!!) - DateDiff
>(I think) was a function within this. IF it has gone, YEARFRAC is still
>there - if you use INT(YEARFRAC(day1,day2)) you will get the whole number
>result you want... if you want the days and months etc, remove the INT part!

The worksheet function is DATEDIF (only 1 F), and it's part of Excel proper.
You don't need the ATP to use it. OTOH, VBA does have a DateDiff (2 F's)
function.


--
Myrna Larson
e-mail to: myrna...@csi.com

Ed Correia

unread,
Jan 30, 1999, 3:00:00 AM1/30/99
to
Is there such a thing as Time-Diff? I am trying to calculate the time which has
passed between the beginning of a job to the end of the job. But I can't seem to
find anything to do this.

Any help would be GREATLY appreciated.

--Ed

Aidan

unread,
Jan 31, 1999, 3:00:00 AM1/31/99
to
Excel stores dates and times as numbers - the whole number is days, the
fractional part the time - so if you have two times, you can do one minus
the other to get the fraction of a day - which multiplied up by 24 would
give you hours and fractions.
Ed Correia wrote in message <36B33739...@pacbell.net>...
0 new messages