I am wondering if someone could help me with this issue?
I would like to have a display of dates to corresponding a specific weekday (e.g. Mondays), as shown below:
Book1.xlsx
01/01/2023 7 Sunday Desire result
02/01/2023 1 Monday 02/01/2023 Monday
03/01/2023 2 Tuesday 09/01/2023 Monday
04/01/2023 3 Wednesday 16/01/2023 Monday
05/01/2023 4 Thursday 23/01/2023 Monday
06/01/2023 5 Friday 30/01/2023 Monday
07/01/2023 6 Saturday 06/02/2023 Monday
08/01/2023 7 Sunday
09/01/2023 1 Monday
10/01/2023 2 Tuesday
11/01/2023 3 Wednesday
12/01/2023 4 Thursday
13/01/2023 5 Friday
14/01/2023 6 Saturday
15/01/2023 7 Sunday
PS, I ma using Microsoft office 2016.
Bookmarks