Add days between start date and end date

Hello,

I need help on date formula. What I am trying to accomplish is, to add days from the start date (daily) and to stop adding at the end date.

Example:
(Column A) Start Date: 1/9/13
(Column B) End Date: 1/8/14

Thank you,
dache416

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

Try this:

=B1-A1

Format the cell as General or as a Number. You may need to add 1 at the end of the formula if you want those dates to be inclusive.

Hope this helps.

Pete