ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 282
- Office Version
- 365
- Platform
- Windows
Gurus,
Is there a way that excel can be able to complete a missing date in a date range.. see below..
Is there a way that excel can be able to complete a missing date in a date range.. see below..
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
2 | SOURCE DATA | ||||
3 | NAME1 | 01-08-22 | 08-24-2022 12:00 | ||
4 | NAME1 | 02-08-22 | 08-22-2022 10:00 | ||
5 | NAME1 | 08-08-22 | 08-22-2022 10:00 | ||
6 | NAME2 | 01-08-22 | 08-24-2022 12:00 | ||
7 | NAME2 | 05-08-22 | 08-22-2022 10:00 | ||
8 | NAME2 | 06-08-22 | 08-24-2022 12:00 | ||
9 | NAME2 | 07-08-22 | 08-24-2022 12:00 | ||
10 | NAME2 | 10-08-22 | 08-22-2022 10:00 | ||
11 | |||||
12 | |||||
13 | EXPECTED RESULT | ||||
14 | |||||
15 | NAME1 | 01-08-22 | 08-24-2022 12:00 | ||
16 | NAME1 | 02-08-22 | 08-22-2022 10:00 | ||
17 | NAME1 | 03-08-22 | |||
18 | NAME1 | 04-08-22 | |||
19 | NAME1 | 05-08-22 | |||
20 | NAME1 | 06-08-22 | |||
21 | NAME1 | 07-08-22 | |||
22 | NAME1 | 08-08-22 | 08-22-2022 10:00 | ||
23 | NAME2 | 01-08-22 | 08-24-2022 12:00 | ||
24 | NAME2 | 02-08-22 | |||
25 | NAME2 | 03-08-22 | |||
26 | NAME2 | 04-08-22 | |||
27 | NAME2 | 05-08-22 | 08-22-2022 10:00 | ||
28 | NAME2 | 06-08-22 | 08-24-2022 12:00 | ||
29 | NAME2 | 07-08-22 | 08-24-2022 12:00 | ||
30 | NAME2 | 08-08-22 | |||
31 | NAME2 | 09-08-22 | |||
32 | NAME2 | 10-08-22 | 08-22-2022 10:00 | ||
Sheet1 |