Hi All,
I had to calculate the total number of heating degree days (HDD) and cooling degree days (CDD) between 05/01/2008 and 30/04/2009, which I did.
The question is, how do I find the number of HDD and CDD between any given date range. For example number of HDD and CDD between 08/13/2008 and 10/20/2008, the date range can be anything. I am using excel 2013.
I have attached the xls file. There is no sensitive data. Please see sheet 2.
Thanks.
Bookmarks