Yes you are correct my week starts from wednesday and end on thrusday.

I have attached a workbook to have a Idea how I need it.

Thank you for reply I check the link for first issue and let you know. For second issue example my current week day is Thursday I look for example that...