Find specific day in date range

If I have a date range, how can I find the (serial) date of a specific day, assuming if falls in the range? Allow me to explain. Let's say my date range is 1/28/2022 (inclusive) to 2/1/2022 (exclusive). How can I:
a) check whether there's a Sunday in that date range.
b) get the actual (serial) date for that Sunday.

In the attached workbook I have the date range and the formula that tells me how many Sundays are in the date range. But I don't know how to get the actual (serial) date for that Sunday.

And to keep things simple, I know that the date ranges I will be working with will, at the most, have ONE single Sunday, or no Sunday at all.

How about

Formula:

Please Login or Register  to view this content.

Aha, perfect, thank you. That gets me what I needed.

You're welcome & thanks for the feedback.