Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Days Between Variable & Fixed Dates
I have 3 fixed dates that represent effective date of
prices: 01/01/2004 04/01/2004 07/01/2004 12/31/2099 Now, I have a billing period (variable) that falls somewhere between 01/01/04 and 12/31/2099; i.e. 3/15/2004 to 4/15/2004 I need to be able to prorate across these price changes based upon the billing period, which is a variable. Specifically, I need to know the number of days to charge at 01/01/2004 prices, 04/01/04 prices, etc. Any assistance in regards to how this can be done in Excel would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Days Between Variable & Fixed Dates
David,
on your worksheet try this: Fixed Date Variable Date Difference(input this formula) 01/01/04 02/03/04 =IF(ISBLANK(B2),0,(DAYS360(A2,B2))) 04/01/04 04/15/04 =IF(ISBLANK(B3),0,(DAYS360(A3,B3))) and so on HTH Charles "David" wrote in message ... I have 3 fixed dates that represent effective date of prices: 01/01/2004 04/01/2004 07/01/2004 12/31/2099 Now, I have a billing period (variable) that falls somewhere between 01/01/04 and 12/31/2099; i.e. 3/15/2004 to 4/15/2004 I need to be able to prorate across these price changes based upon the billing period, which is a variable. Specifically, I need to know the number of days to charge at 01/01/2004 prices, 04/01/04 prices, etc. Any assistance in regards to how this can be done in Excel would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting days between dates | Excel Discussion (Misc queries) | |||
Counting days between 2 dates | Excel Discussion (Misc queries) | |||
Counting Days Between Dates | Excel Worksheet Functions | |||
Difference between 2 dates, incl weekends, with variable work days | Excel Discussion (Misc queries) | |||
Counting days between dates | Excel Discussion (Misc queries) |