How to convert given date into month number in excel. But the number should start with July. For example if month in the date provided is july , it should return 1 as month number, if august 2 .

Please provide screenshot.

For example:

Date	Month number
04/11/2022	10
07/11/2022	1

9. Assume the normal PDF is a good model for stock returns. Your firm has created a "fund" (a portfolio of stocks) with an expected annual return of 13% and a standard deviation of 0.18. Risk-free bonds are paying 80 basis points per year. A client wants a portfolio with a 5% Value-at-Risk of -14%. (A) If your client puts all his money in the fund, what is his 5% Value-at Risk? (B) Show how you would construct the portfolio desired by your client using risk-free bonds and the fund created by your company. (C) What is the expected return of your client's portfolio? (D) Interpret what it means to have a portfolio with a 5% Value-at-Risk of -14%. (E) If your client has $50,000, how much should he put in the fund, and how much should he put in risk-free bonds to achieve her objective? (F) If the fund is composed of 20% in stock A and 80% in stock B, what is your client's implicit weight in stock B and stock A?