james_simpson1998
New Member
- Joined
- Jul 30, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi people,
What I am trying to do is this, this is an example so not the exact wording:
Cell A4 contains a week number, example 40.
Entering forumla into cell A6: If cell A1 equals "A" and cell A2 equals "B", convert cell A4 into week number date, i.e week 40 = 28/09/2020.
is there a formula that can do this please?
thank you advance.
What I am trying to do is this, this is an example so not the exact wording:
Cell A4 contains a week number, example 40.
Entering forumla into cell A6: If cell A1 equals "A" and cell A2 equals "B", convert cell A4 into week number date, i.e week 40 = 28/09/2020.
is there a formula that can do this please?
thank you advance.