Hi,
I'm trying to get my spreadsheet to auto fill up the yellow cells, based on the info in the green cell. Example as below:
Cell A6 is the first 3 months period from cell B1. For example, if B1 is 1 Feb 21, then A6 will be "Feb - Apr 21". Cells B6:D6 are subsequent 3 months period from the corresponding cells on the left. Is there anyway to do it?
Thanks!
I'm trying to get my spreadsheet to auto fill up the yellow cells, based on the info in the green cell. Example as below:
Cell A6 is the first 3 months period from cell B1. For example, if B1 is 1 Feb 21, then A6 will be "Feb - Apr 21". Cells B6:D6 are subsequent 3 months period from the corresponding cells on the left. Is there anyway to do it?
Thanks!