Difference between Dates -Version 97 SR-2

[sachinattri]

Simple, have to calculate difference between dates in Years or Days an
I am using the DATEDIF Function but my Excel Version is not taking it
I use Excel 97 SR-2 on Windows NT. Its official so cant change th
version.

Any help?

Thank yo

 

[Ron Rosenfeld]

I am using the DATEDIF Function but my Excel Version is not taking it.

What in the world does "not taking it" mean???

Excel 97 did have the DATEDIF function implemented, so it may be that you are
using it incorrectly.

If you would post the data and formulas you are using, you might be able to get
some good assistance.


--ron

 

[Chip Pearson]

What do you mean by "not taking it"? What sort of error result
are you getting? See www.cpearson.com/excel/datedif.htm for
details about the DATEDIF function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[sachinattri]

The formula I am using is

Cell A1 Cell B1
1/1/2003 1/1/2004

=datedif(A1,B1,"y")

Hope this is clear. The error msg I am getting is "The formula yo
typed contains an error"

Thank

 

[Frank Kabel]

Hi formula looks o.k. Onr idea:
do you use the coma as list seperator or do you use the semicolon?

 

[sachinattri]

I use a comm

 

[Frank Kabel]

Hi
does Excel highlight a specific part of your formula?

 

[Ron Rosenfeld]

I use a comma

I get your reported error result if I use an improper list separator.

Can you check your regional settings and see what it says the List Separator
is?

Or if not, enter and run the following Macro to see:

==========================
Sub ListSeparator()
MsgBox ("The List separator is: " _
& Application.International(xlListSeparator))
End Sub
==========================

To enter the macro, <alt-F11> opens the VB editor. Ensure your current project
is highlighted in the project explorer window. Then Insert/Module and paste in
the code above.

Then return to the worksheet. <Alt-F8> and select the macro -- ListSeparator
-- and <RUN> it.

See what it says your List Separator is.


--ron