DATEIF Formula

[mikeywhits]

Hi all,

I currently have the following formula

=IF(I1>TODAY(),0,DATEDIF(I1,TODAY(),"d"))

This basically calculates the number of days from the date inputted into I1 up until todays date, placing an "0" if the date inputted into I1 has not occured yet.

As i have 10 lines of this running from I1 to I10 i have input a =SUM(I1:I10) to calculate the total days of all these rows. Supposing none of these dates have occured yet, the formula places ten "0"'s into each row along column I, though the SUM figure of these gives an total of 40722.

Can anyone help please?

 

[barry houdini]

40722 is the date serial number for today's date - 28th June 2011 - are you sure you are summing the right range - it can't be I1:I10 where the formulas are if the formulas also reference that range?

 

[mikeywhits]

Sorry guys,

dont worry about this, i have found some hidden rows.

Idiot!

 

[mikeywhits]

thanks anyway for taking a look Barry