View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Query equasion for dates

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