Forum Discussion

aidanLA's avatar
aidanLA
Copper Contributor
Apr 18, 2024

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 one bit that isn't right. please can anyone help?

 

TIA

 

Aidan

    • aidanLA's avatar
      aidanLA
      Copper Contributor
      Amazing, thanks Hans! Who knew i was over complicating it!!

Resources