Replace part of formula in a specific cell range Simply select the cell range press CTRL H to open the Find and Replace dialog box. Take all formulas to the clipboard by pressing CtrlC on your keyboard. You can replace day month and year using the function Replace in Google Sheets.
Google Sheets formulas can calculate data not only from the same sheet they are.
To copy C1s function to the other table rows in column C with the fill handle follow these steps. Change - The change in the most recently reported net asset value and the one immediately prior. This prevents Google Sheets from changing the references when youre copying. Click on Format and then on Number.