In the example below I have a column of dates in column B, when I update the first date in the column (which font it bolded) I want the other dates to automaticlly update the month only. Is it possible to do this with a formula. Example if I change the bolded date to 03/10/2022 I want the other dates to start with 03 also. Looking for a formula to do this. I have idea where to start? Thank You in advance....
1 | 02/10/2022 |
2 | 02/10/2022 |
3 | 02/13/2022 |
4 | 02/13/2022 |
5 | 02/15/2022 |
6 | 02/18/2022 |
7 | 02/18/2022 |
8 | 02/19/2022 |
9 | 02/17/2022 |
10 | 02/20/2022 |
11 | 02/20/2022 |
12 | 01/24/2022 |
13 | 01/24/2022 |
14 | 01/24/2022 |
15 | 01/26/2022 |
16 | 02/15/2022 |