Forum Discussion
Dynamic month list
I have an Excel sheet which contains a couple of formulas where you can fill in the date inside a cell and it automatically displays the whole month with the correct day of the week, month and year. ...
Hi Twan,
Sorry for the late reply!
I understood from your explanation that you want to put the week number and then you want to extract all dates under this week number!
For example, if you put 14 (which is the current week number), then you will get a result as below screenshot:
I've updated the solution to do that for you, but it depends on a separate sheet contains the all the dates in the year 2018 with the week number for each date.
This is works only on a predefined year.
Please find the attached file.
Hope that helps
Thank you so much Haytham! Do I thank you by giving you a thumbs up and mark your post as best reply?
Thank you for this appreciation!
This encourages us to continue to help!
If you have any other question, don't hesitate to ask.
This encourages us to continue to help!
If you have any other question, don't hesitate to ask.