Forum Discussion
aidanLA
Apr 18, 2024Copper Contributor
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
- aidanLACopper ContributorAmazing, thanks Hans! Who knew i was over complicating it!!