Add days between start date and end date

The attached spreadsheet shows what I am trying to accomplish. The formula currently in used continuously adds days indefinitely without stopping at the end date. I tried playing with the formula to no avail.

Any help, is greatly appreciated

dache

Put this in A5:

=IF(B$1="","",B$1)

and this in A6:

=IF(OR(B$2="",A5=""),"",IF(A5+1>B$2,"",A5+1))

Copy the formula in A6 down as far as you need to (until you start to get blanks).

Hope this helps.

Pete

Thank you very much Pete

You're welcome - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete