lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi I have dates like the one below
In the second column, I entered in B4 =1 (first friday) and then B7 = 2 (first Monday), now I want to auto fill that so the next Friday will be 3 and Next monday will 4 and then Next friday is 5 and next monday is 6
So how can I do that automacially? Thank you so much
In the second column, I entered in B4 =1 (first friday) and then B7 = 2 (first Monday), now I want to auto fill that so the next Friday will be 3 and Next monday will 4 and then Next friday is 5 and next monday is 6
So how can I do that automacially? Thank you so much
Tue, 01-Sep-20 | |
Wed, 02-Sep-20 | |
Thu, 03-Sep-20 | |
Fri, 04-Sep-20 | 1 |
Sat, 05-Sep-20 | |
Sun, 06-Sep-20 | |
Mon, 07-Sep-20 | 2 |
Tue, 08-Sep-20 | |
Wed, 09-Sep-20 | |
Thu, 10-Sep-20 | |
Fri, 11-Sep-20 | 3 |
Sat, 12-Sep-20 | |
Sun, 13-Sep-20 | |
Mon, 14-Sep-20 | 4 |
Tue, 15-Sep-20 | |
Wed, 16-Sep-20 | |
Thu, 17-Sep-20 | |
Fri, 18-Sep-20 | 5 |
Sat, 19-Sep-20 | |
Sun, 20-Sep-20 | |
Mon, 21-Sep-20 | 6 |
Tue, 22-Sep-20 | |
Wed, 23-Sep-20 | |
Thu, 24-Sep-20 | |
Fri, 25-Sep-20 | |
Sat, 26-Sep-20 | |
Sun, 27-Sep-20 | |
Mon, 28-Sep-20 | |
Tue, 29-Sep-20 | |
Wed, 30-Sep-20 | |
Thu, 01-Oct-20 | |
Fri, 02-Oct-20 |