Forum Discussion
Changin dates on multiple spreadsheets
How do I get a cell on multiple sheets to follow a source cell?
Let's say the source cell is A2 on a sheet named Source Sheet.
On the other sheets, enter the formula
='Source Sheet'!A2
where you want to refer to the source cell. Apply the desired date format to the cells with the formula.