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