Posted to microsoft.public.excel.worksheet.functions
|
|
Query equasion for dates
Thank you, Bernard!
"Bernard Liengme" wrote:
Try
=TODAY()-A1
assuming A1 holds the first date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"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
|