Since Excel dates are really integers, just type 12/31 (Excel will
automatically supply the current year) in cell A1, type 3/31 in cell A2, and
the formula =A1-A2+1 in cell A3. You should get 276 as the answer.

"smooney" wrote:

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