Hi,
try to use the DATEDIF funcion, as:

=datedif(a2;a1;"d")

assuming a1 = 12/31/2007 and a2 = 03/31/2007

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"smooney" escreveu:

I'm wondering if there is a formula that will calculate the number of days
from a given date until the end of the year. So if I have a date of Mar 31,
2007...I want to know how many days (including that day) between then and Dec
31.

Thanks