Owner's Manual

VC = variable cost
Q = quantity
Days between Dates
With the Date worksheet, you can enter or compute a date within the range
January 1, 1980, through December 31, 2079.
Actual/actual day-count method
Note: The method assumes the actual number of days per month and per year.
DBD (days between dates) = number of days II-number of days I
Number of Days I = (Y1 -YB) Q 365
+ (number of days MB to M1)
+ DT1
Number of Days II = (Y2 -YB) Q 365
+ (number of days MB to M2)
+ DT2
where:
M1 = month of first date
DT 1 = day of first date
Y 1 = year of first date
M 2 = month of second date
DT 2 = day of second date
Y 2 = year of second date
MB = base month (January)
DB = base day (1)
YB = base year (first year after leap year)
APPENDIX - Reference Information 91