I'm doing an analysis of energy bills and need to account for daily weather differences (heating and cooling degree days). I have the start and end of each billing period, and need to use those to look up the degree days for each day within the billing period. I.e., if I give Excel a range of say, 6/18/08 - 7/18/08, can I have it scan a column with all of the individual dates in that range and pull the corresponding degree day values?
THANKS SO MUCH!
Bookmarks