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

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

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