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.

 

Julius575_0-1637830247389.png

 

1 Reply

@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)