I'm using the following formula to display the SUM number of days fom within a a series of dates

=SUM(DATEDIF(A2:A23,B2:B23,"d"))

for example Column A has the start date and Column B has the end date.

9/1/2009 10/1/2009
10/1/2009 10/31/2009
10/17/2009 10/24/2009
10/24/2009 10/31/2009
11/7/2009 11/14/2009
11/10/2009 11/19/2009
12/25/2009 12/31/2009
12/25/2009 1/1/2010

The above formula had worked previously but now when I try to use the formula instead of showing the total number of days I get #VALUE!

If i click on the equal sign in front of my formula the box that pops up shows the correct sum that my formula should display but for some reason it's not displaying the number down in the cel.

I'm running Excel 2000 on windows XP