Forum Discussion
Formula help
Please can someone advise on a formula. Row 1 contains the dates of March, Column A contains name, Column B contains arrival date and Column C contains departure date. I would like to put t...
Think I've sussed it :-
=IF(D$1=$B2-1,2,IF(D$1=$C2+1,1,IF(AND(D$1>=$B2,D$1<=$C2),3,"")))