Date Difference

[Soefje]

I am porting an Excel spreadsheet I use for Little League baseball in which I need to calculate the league age of each player.

In Excel I use the DATEDIF function, putting the kids birthdate in one column and the index date in an anchored cell, then have it rounded to the the number of years to calculate the league age.

When I opened this spreadsheet in OpenOffice Calc, I got #VALUE in the cell. I could not find a DATEDIFF function. Is there something like that in Calc?

Thanks,
_________________
Scott Soefje
San Antonio, TX

[carl]

col C is dates in col B minus dates in col A , formatted as a date.
_________________
carl
Using OpenOffice.org 2 on XP sp2

[David]

[quote="Soefje"]In Excel I use the DATEDIF function/quote]

I couldn't see that function [either spelling] in Excel version 2000. Which version are you using? A simple difference in dates is found by subtraction and ofrmatting as pointed out by Carl.

David.

[Soefje]

I am using Excel XP.
_________________
Scott Soefje
San Antonio, TX

[Sliderule]

Soefje:

Rather then use the datediff function . . . use . . . years

=YEARS(A2; B2; 0)

In the above example . . . A2 is the 'start date' (or kid's birthday in your example) . . . B2 is the 'end date' (index date in an anchored cell in your example) and the third entry, o is to tell Calc - the type of difference . . . pPossible values are 0 (interval) and 1 (in calendar years).

I hope this helps . . . and . . . please let us / me know.

SlideRule

[french]

There's a nice explanation of DATEDIF at:

http://www.cpearson.com/excel/datedif.htm

[David]

[williamts99]

I use =YEARS(A2;TODAY(); 0) to calulate age without having to have an extra reference cell with today's date in it.