Changin dates on multiple spreadsheets

Copper Contributor

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

1 Reply

@Mike_Dob 

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.