Return 1 or 0 based on Date Range

6StringJazzer,

Thanks for you help! After I finished modifying the sheet you gave me I noticed I needed more granularity, weeks vice months. I attempted to modify what you did to work with weeks and it looks like everything worked with one exception. When the last day of the week conicides with the first day of use I get a 0 instead of a 1. I tried to figure out why the error was occurring but my attempts to modify the formula create either an error or the same result. In the attached file on the "weeks covered" sheet, row 390 for asset A is an example of there being no tally, 0 vice 1. I am guessing this is something similar to counting the number of days between 2 dates including the start and end date. The only way I could get an accurate number was to add 1 every time. Any help you can give me is greatly appreciated!

Thanks again!