Jan 05 2021 11:07 AM - edited Jan 06 2021 11:10 AM
Hi,
Would anyone know a formula we can use to autofill dates but have 10 lines on each weekday dates so then we only have to update the start and end dates? This is needed for time & task management sheet.
See below illustration:
A B C D
1 Period Starting: 01 January 2021 Period Ending: 31 December 2021
2
3 Day Date
4 =TEXT(B4, "dddd") =B1 (Output: 1/Jan/21)
5 =TEXT(B5, "dddd") = Formula???
Final output required should show below result:
A B C D
1 Period Starting: 01 January 2021 Period Ending: 31 December 2021
2
3 Day Date
4 Friday 1/Jan/21
5 Friday 1/Jan/21
6 Friday 1/Jan/21
7 Friday 1/Jan/21
8 Friday 1/Jan/21
9 Friday 1/Jan/21
10 Friday 1/Jan/21
11 Friday 1/Jan/21
12 Friday 1/Jan/21
13 Friday 1/Jan/21
14 Saturday 2/Jan/21
15 Sunday 3/Jan/21
16 Monday 4/Jan/21
17 Monday 4/Jan/21
18 Monday 4/Jan/21
19 Monday 4/Jan/21
20 Monday 4/Jan/21
21 Monday 4/Jan/21
22 Monday 4/Jan/21
23 Monday 4/Jan/21
24 Monday 4/Jan/21
25 Monday 4/Jan/21
Appreciate any help, thank you in advance. :)