Hello,

I'm using Excel 2007 and somewhat limited when it comes to formulas.

I have a spreadsheet with two sets of date ranges that I need to specify a random date between the two; however, I need that random date to only fall on a Sunday.

My spreadsheet looks like this:

Column F = Start Date
Column G = End Date

I need in Column "H" a random date; but that date can only fall on a Sunday
I need in Column "I" a second random date that cannot duplicate any which are in Column H that too falls on a Sunday.

Is this possible?

Many Thanks!

excel forum.jpg