hello,
I am looking for a solution to my excel problem - i have 2 columns that i need to populate text into that are determined from a date range in a different cell.
For example: this is my date range - and I need 2 seperate columns one that names the week something is Due and the second column to determine the date due. Please let me know if this makes any sense.
Week 1 would be the date range of 4/15/23 - 10/2/23 and any dates on 4/15 to 7/21 will be Monday , 9/1-9/30 would be wednesday etc..
Due_Date
4/15/2023
7/11/2023
7/21/2023
9/1/2023
9/12/2023
9/13/2023
9/30/2023
10/2/2023
10/2/2023
10/16/2023
10/16/2023
10/17/2023
10/19/2023
10/22/2023
10/24/2023
10/26/2023
10/27/2023
10/27/2023
10/27/2023
10/28/2023
10/28/2023
10/28/2023
10/29/2023
10/29/2023
10/29/2023
10/29/2023
10/29/2023
Bookmarks