With the start date in column A, in B1 enter:

=DATE(2008,12,31)-A1

then format B1 to integer
--
Gary''s Student - gsnu200767


"Jyoti" wrote:

Hello,

I have a column of start dates and another column to figure out the number
of days between start date and the end of the year. The formula I want to
enter is
=31 Dec 2008 - Start date
This will give me the number of billable days in 2008.
I can populate this data by putting 31-dec-2008 in a cell and referring to
it. However, is there anyway to put this date in the formula itself?

Regards