Not sure I've interpreted correctly, but I'll start with this. With the understanding the days listed are in week 1 of June 2021 this in A3 and filled down.
Not sure how many formulas you will be using I created some array constants to eliminate redundant calculations.
And BTW in A4 I get 6/1/2021 which is correct.
|
A |
B |
C |
D |
E |
F |
G |
1 |
Month |
June |
|
Year |
2021 |
|
|
2 |
Date |
Days |
Time
in |
Lunch
Out |
Lunch
In |
Time
Out |
Out of
Office |
3 |
6/7/2021 |
Monday |
|
|
|
|
|
4 |
6/1/2021 |
Tuesday |
|
|
|
|
|
5 |
6/2/2021 |
Wednesday |
|
|
|
|
|
6 |
6/3/2021 |
Thursday |
|
|
|
|
|
7 |
6/4/2021 |
Friday |
|
|
|
|
|
Bookmarks