LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i make a formula thart rep equasion X/b=12 if b = cell c12 shamppy Excel Worksheet Functions 2 May 24th 07 01:38 PM
Group Dates from SQL Query wjvii Excel Discussion (Misc queries) 1 March 22nd 07 11:52 PM
How do I export dates into a query? tires85 Excel Discussion (Misc queries) 0 August 11th 06 09:16 PM
How do I get my dates in a report to export into my query? tires85 Excel Discussion (Misc queries) 0 August 11th 06 04:07 PM
dates in query patrick @fizz Excel Worksheet Functions 0 April 8th 05 07:43 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"