Forum Discussion

aidanLA's avatar
aidanLA
Copper Contributor
Apr 18, 2024
Solved

IF formula with multiple date scenarios (including AND)

Hi There   I'm trying to have a formula calculate how many days people stay based on an arrival and departure date. I've got the majority of the formula working, however there always seems to be o...
  • HansVogelaar's avatar
    Apr 18, 2024

    aidanLA 

    In C4:

     

    =MAX(MIN(B4-1, $B$2)-MAX(A4, $B$1)+1, 0)

     

    Fill down.

Resources