bbrimberry
New Member
- Joined
- Mar 23, 2016
- Messages
- 34
Hello,
I am curious if someone can help me solve for this.
I would like to be able to take input from the user or store in the input in a cell
I have the table below.
I would like to take the input from the user such as 02/01/2020 and let power query fill the date table
I have a macro that does this but I would like to solve for it in power query.
Is this possible?
I am curious if someone can help me solve for this.
I would like to be able to take input from the user or store in the input in a cell
I have the table below.
I would like to take the input from the user such as 02/01/2020 and let power query fill the date table
I have a macro that does this but I would like to solve for it in power query.
Is this possible?
date.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Week and Day | Real Date | ||
2 | Week 1 Monday | 02/01/2021 | ||
3 | Week 2 Monday | 02/08/2021 | ||
4 | Week 3 Monday | 02/15/2021 | ||
5 | Week 4 Monday | 02/22/2021 | ||
6 | Week 1 Tuesday | 02/02/2021 | ||
7 | Week 2 Tuesday | 02/09/2021 | ||
8 | Week 3 Tuesday | 02/16/2021 | ||
9 | Week 4 Tuesday | 02/23/2021 | ||
10 | Week 1 Wednesday | 02/03/2021 | ||
11 | Week 2 Wednesday | 02/10/2021 | ||
12 | Week 3 Wednesday | 02/17/2021 | ||
13 | Week 4 Wednesday | 02/24/2021 | ||
14 | Week 1 Friday | 02/05/2021 | ||
15 | Week 2 Friday | 02/12/2021 | ||
16 | Week 3 Friday | 02/19/2021 | ||
17 | Week 4 Friday | 02/26/2021 | ||
18 | Week 1 Thursday | 02/04/2021 | ||
19 | Week 2 Thursday | 02/11/2021 | ||
20 | Week 3 Thursday | 02/18/2021 | ||
21 | Week 4 Thursday | 02/25/2021 | ||
Sheet1 |