Zend certified PHP/Magento developer

Excel 2013 Analyzing Multiple Dates within a single Cell using IF statements

Is there are way to analyze multiple dates within an a single cell in excel using IF statements?

For Example, I have the following dates in a single cell (A1):
1/2/23, 4/6/23, 10/3/23

Is there are to say if any of the values in (A1)>= 4/1/223 AND <= 9/30/23 then return a “Yes”?

Not sure if this question is clear.