We have a spreadsheet which is used as input for test data for testing mainframe programs. One of the items we do manually is calculate a date this way. Cell B4 has a "from date". Cell B5 has a "to date". Cell B6 has a day of the week, e.g. "Wednesday". What we have to do is come up with a date for a Wednesday between the "from date" and the "to date". Assuming the "from date" is "July 22/04" and the "to date" is "Aug. 21/04", how can we find a date for a Wednesday within that date range. I will even settle for the first Wednesday. We then have Mondays, etc. The output needs to be in the format of YYMMDD. Is this possible???????