Forum Discussion

Gordon22's avatar
Gordon22
Copper Contributor
Jun 28, 2022

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...
Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 28, 2022

    Gordon22 

    =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. 

Gordon22's avatar
Gordon22
Copper Contributor
Hi Jitinm,

Yes, that what i was looking for - i will need to go through these and see if i can follow, but the function is correct, thank you for taking the time.

Thanks.
jitinm's avatar
jitinm
Iron Contributor
Jun 28, 2022
Do let me know if there is any problem.