I'm working on a spreadsheet that includes a static Sunday through Saturday
list in one row. Above that row, I have a place to enter the dates for each
day. I'm looking for a way to allow entry into any of the seven cells for the
date, and for the remaining six cells to auto calculate and populate the
date. Here's an example of the layout:

Row A: |Date|Date|Date|Date|Date|Date|Date|
Row B: |Mon|Tue|Wed |Thur| Fri | Sat |Sun |

Again, I want to be able to put a known date in any of the cells above the
day of the week it corresponds with (the cells labeled "Date"), and have the
other 6 cells auto populate the date.

Any help is appreciated,

CVinje