Thank you, David.

Although, isn't this for a number equation.

I'm wanting the days to reflect the dates of line item additions (which will
be added to), so I will enter the date and I want the equation to (on an
ongoing basis) to calculate the calendar dates from the last entry (which
will change). The first date will be the longest days from the last entry?

Thanks,
Dave

"David Biddulph" wrote:

=A3-A2 and format as number or general.
--
David Biddulph

"Dave" wrote in message
...
I am trying to create an Excel doc that will include dated line items.

Within this listing, there will be one column that needs to calculate one
line items date from the original date (the purpose is to show days
accrued
for interest).

Would you please inform me how to create a query or column equasion to
tally
the accrued date?

example.

01/01/2007 365 days company a investment

11/30/2007 32 days company a investment

01/01/2008 0 days company a investment


Thank you.

Dave