No. of days computation or date computation

New Contributor

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.




1 Reply

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




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: