No. of days computation or date computation

[Julius575]

Hi Community Excel,

Pls assist me to compute no. of days in column O.

L0 & E1 = should be equal to 1 (same day only)

L1 & E2 = should be equal to 2 (different date)

if departure is 7 days after arrival, the days should be equal to 8 days.

[#2]

@Julius575 If it's just the number days your are after, enter in O10:

=E11-L10+1

Format cell O10 as General and copy down. To prevent a calculation in case there is no departure date on the next row in column E, use this:

=IF(E11="","",E11-L10+1)