Changin dates on multiple spreadsheets

Occasional Visitor

How do I get a cell on multiple sheets to follow a source cell?

1 Reply


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.