Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong! Is
it the year change?

TIA