Give me formula and where to post for the answer

Fitness Center The manager at a local fitness center has asked you to do some analysis of membership and trainers employed by the fitness center. The Fitness Center worksheet contains records about the members. The manager would like some details about how long they have been members, and how many pay for trainers as part of their membership. He would also like some insights about each of the trainers. Complete the tasks to provide the information to the manager. (1.7) The manager would like to start creating a "Membership ID" that can be used to identify the member. In cell B3), use the CONCAT function to create a Membership ID with the pattern: Year of sign up date, Last Name, month of sign up date. For example: a member with the last name Jones that signed up 12/2/2023 would have a membership id of -2023Jones12. - Use the CONCAT (or CONCATENATE) function with nested YEAR and MONTH functions. - Reference the members Last Name in column D in your function. - Copy and paste the function down the column to create the "Membership ID" for the other members. (1.6) The manager would like to know how many members had trains and how many did not. In cell 014), use a COUNTA function and the data in column I to calculate how many members have a trainer. In cell 015), use a COUNTBLANK function and the data in column I to calculate how many members do not have a trainer