Dates and formulas

[shakes347]

Hey all,

I need help with a formula.

I have two columns of dates, beginning date and end date. I need a separate cell that will search all the end dates and compare them to the next beginning date and calculate the number of days between the two. If the number of days is 35 or greater I need that cell to populate with that number. If the number is under 35 I need the cell to be blank.

Then, if the number is 35 or greater, I need two other cells to populate with the day after the end date and the day before the next beginning date.

For some context - I have one sheet that lists classes that a student is taking and another that shows breaks in attendance. What I would like the second sheet to do is auto-populate from the first if the student takes any breaks 35 days or greater. The sheet should show the beginning of the break (the day after the last day of attendance) and the end (the day before the next class starts) as well as the number of days off.

Is this even remotely possible?

Let me know if you need some clarification.

Thanks!

[JBeaucaire]

How about this in C2 to compare the dates in A2 (begin) and B2 (end):

=IF(B2-A2<36, "", B2-A2)

...then copy that cell downward. If Excel gets weird, be sure to format the column as General.

[Cheeky Charlie]

JB, I think you meant:
=IF(B2-A2<36, "", B2-A2)

hth