If it's a well-known problem, and you know how to do it, please provide a solution.
If you do not wish to assist our members with EITHER specific links to specific help online OR a solution yourself, please refrain from posting.
You have made the forum seem unfriendly and unhelpful.
Apologies for the unfriendly 'welcome'.
Please have a look at this tutorial, which should help you: https://exceljet.net/formulas/get-w…dates-and-times