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
Bookmarks