i have made up the cells already but what i need assistance with. In 14
different cells I would like 2 weeks of dates to come up. so if today is
monday, in the monday cell it shows todays date, but on tuesday in the
tuesday cell its show the next day still showing yesterday in the monday cell.

also I have tried repeatly to make a drop down menu from an array on sheet2.
I would like this array to be visible as a drop down within cells on sheet 1.
can someone help me