| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days in a quarter between two date ranges
I am trying to develop a table that will split a cost over quarters. The data
that I have is: A B C D E F G Base Cost Task Start Task End Task Duration Cost per day 08Total 09Total 728.00 02-Nov-2008 31-May-2009 30.16 3.45 215.17 564.00 The total cost per year takes the percentage of time in that year and then adds an inflation factor (which is why the total is higher than the base). What I need to do is write a formula that will split each year into quarters. In this example all the cost for 08 will be in Q4 etc. Many thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in overlapping date ranges (using array formula?) | Excel Worksheet Functions | |||
| Counting Days of Week in Date Ranges | Excel Worksheet Functions | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| Count of days in a quarter | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Threaded Mode
