Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
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 |
#3
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
01/01/2007 =TODAY () A1 (365 days) company a investment
11/30/2007 =TODAY () A1 (32 days) company a investment 01/01/2008 =TODAY () A1 (0 days) company a investment I want the first date to be the furthest date and the current day to be the days from Is this correct? Thanks, Dave "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
=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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
Thank you all, here is the answer:
Column 1 gives you todays date. Column 2 gives you the date of transaction. Column 3 provides a dynamic equation for financials. For me, this is used for keeping a running list on investment days for interest. Column 1 Column 2 Column 3 =today () date of transaction =A1-B1 Right click Right click -Format Cells -Format Cells -Number -Number -Set decimal @ 0 -Set decimal @ 0 Best, Dave |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
Column 1
=today () Right click -Format Cells -Number -Set decimal @ 0 Column 2 date of transaction Right click -Format Cells -Number -Set decimal @ 0 Column 3 =A1-B1 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query equasion for dates
Perhaps I have misread what you have said, but why would you want to
reformat columns A and B from date to Number? You need column C as Number or General for the answer, but why not leave columns A and B showing dates? -- David Biddulph "Dave" wrote in message ... Thank you all, here is the answer: Column 1 gives you todays date. Column 2 gives you the date of transaction. Column 3 provides a dynamic equation for financials. For me, this is used for keeping a running list on investment days for interest. Column 1 Column 2 Column 3 =today () date of transaction =A1-B1 Right click Right click -Format Cells -Format Cells -Number -Number -Set decimal @ 0 -Set decimal @ 0 Best, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a formula thart rep equasion X/b=12 if b = cell c12 | Excel Worksheet Functions | |||
Group Dates from SQL Query | Excel Discussion (Misc queries) | |||
How do I export dates into a query? | Excel Discussion (Misc queries) | |||
How do I get my dates in a report to export into my query? | Excel Discussion (Misc queries) | |||
dates in query | Excel Worksheet Functions |