Drag the formula down to the other cells in the column by clicking and dragging the little icon at the bottom-right of the cell. To change your default language in Sheets. Im not saying Bring me the contents of cell A2 Im really saying Bring me the contents of the cell thats two cells to the left.
If theres already a rule click it or Add new rule Custom formula is.
First of all let me give you the non-array formula to convert a date to month and year format using this new method. In case you convert the cells that contain formulas to values and want to revert back you can use the keyboard shortcut Control Z. To learn more watch the video above and read the steps below. Highlight the cells you wish to format and then click on Format Conditional Formatting.