Ramballah
Active Member
- Joined
- Sep 25, 2018
- Messages
- 311
- Office Version
- 365
- Platform
- Windows
Hi all,
Im posting this thread because my previous one never got a reply so I'm going to try to reword it. My old thread
What I want in column A is to see the dates from every Wednesday however:
In column K if the minimum date is past the wednesday then I want the next wednesday to show up
So:
So I want in column A to get the first following Wednesday that comes after the min date in column K so the min date is 27/09 and the first Wednesday will be 30/09/2020.
If 15/10/2020 was the min date then it would be A2=21/10/2020
From A3 and further its just A2+7 but I need to get a formula for A2.
If you need more information please let me know.
Thanks in advance,
Ram
Im posting this thread because my previous one never got a reply so I'm going to try to reword it. My old thread
What I want in column A is to see the dates from every Wednesday however:
In column K if the minimum date is past the wednesday then I want the next wednesday to show up
So:
Column A | Column K |
30/09/2020 | 27/10/2020 |
07/10/2020 | 01/10/2020 |
14/10/2020 | 27/09/2020 |
21/10/2020 | 17/10/2020 |
28/10/2020 | 23/10/2020 |
04/11/2020 | 15/10/2020 |
this list keeps going on | This column exists of random dates |
If 15/10/2020 was the min date then it would be A2=21/10/2020
From A3 and further its just A2+7 but I need to get a formula for A2.
If you need more information please let me know.
Thanks in advance,
Ram