FelixExcel
New Member
- Joined
- Sep 14, 2022
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hey all,
I have a table that has one column of dates, one column of days and one column of calender weeks.
For example:
Date Day Week
30.10.22 Monday 40
31.11.22 Tuesday 40
01.10.22 Wednesday 40
30.11.23 Friday 44
I would like excel to find the date if I give it the week and the day. For example, if I write 40 in cell A1 and Monday in Cell A2 I want excel to search through my table and give me back the date that is in the same row as 40 and Monday, so 30.10.22.
I'm sure there is a formula to do this, but I just can't get it to work.
Any help is appreciated.
I have a table that has one column of dates, one column of days and one column of calender weeks.
For example:
Date Day Week
30.10.22 Monday 40
31.11.22 Tuesday 40
01.10.22 Wednesday 40
30.11.23 Friday 44
I would like excel to find the date if I give it the week and the day. For example, if I write 40 in cell A1 and Monday in Cell A2 I want excel to search through my table and give me back the date that is in the same row as 40 and Monday, so 30.10.22.
I'm sure there is a formula to do this, but I just can't get it to work.
Any help is appreciated.