Forum Discussion
Nest Formula
Hi, I am using a formula in a cell:- =IF(AND(AC$1>=$A83,AC$1<=$B83),"1","") It tests the dates entered into 2 row cells (start and stop dates), against a date on each colunm, if true it ente...
=IF(AND(D$1>=$A2,D$1<=$B2,COUNTIF($C2,"*holiday*")>0),2,IF(AND(D$1>=$A2,D$1<=$B2),1,""))Maybe with this formula.
Hi Jitinm,
Thank you for your test, i can't seem to modify this to see it working in my example, also i need to get "holiday" to be checked even within other text.
Below is what i am trying to do - i used =IF(AND(D$1>=$A3,D$1<=$B3,$C3="holiday"),1,0)
| 01/06/22 | 02/06/22 | 03/06/22 | 04/06/22 | 05/06/22 | |||
| 02/06/2022 | 03/06/2022 | test 1 | 1 | 1 | |||
| 01/06/2022 | 04/06/2022 | test 2 | 1 | 1 | 1 | 1 | |
| 03/06/2022 | 05/06/2022 | test 3 holiday | 2 | 2 | 2 |
Sorry - i can seem to upload the sample i did!
Thanks
