How do I get a worksheet to automatically update dates with cells, when the
cells are not next to one another, i.e. 1-jan is in cell a3 and i would 2-jan
to appear in a7 automatically??

Help.
I can email the worksheet if you like!