# Date range (If Statement)

#### Manuel998

##### Member
Hi Team,

I am looking to see that if any number is present in the data table and fall within the date range specified then can it return yes. your help is much appreciated workbook sample attached.

Thanks!

#### Attachments

• 11.6 KB Views: 7

#### rahulshewale1

##### Active Member
hi @Manuel998,

see if is ok ?

R7: Copy Across
=IF(AND(R\$1>=\$CB\$2,R\$1<=\$CC\$2),"Yes","No")

#### Manuel998

##### Member
Thanks Rahul but it did not work i basically need a formulae in cell CB7 that looks at the data in columns R:BY and if they are within the date range of 5 Yrs (cells R1:BY) and they have a value in cell R7 or any other cell between R7 and BY7 then the result in CB7 should show yes.

#### Manuel998

##### Member
any help on this will be much appreciated as i have tried a few if statements and it doesn't seem to give me the answer i need?

#### rahulshewale1

##### Active Member
Thanks Rahul but it did not work i basically need a formulae in cell CB7 that looks at the data in columns R:BY and if they are within the date range of 5 Yrs (cells R1:BY) and they have a value in cell R7 or any other cell between R7 and BY7 then the result in CB7 should show yes.
Hi @Manuel998,

But there is no value in B7:BY7 ?