Date Look-Up Calculation

[David Brown]

Happy Xmas,
Thanking you in advance. I have attached sheet example FYI.
Two part question:
(i) Format to convert date to Q1-YY (refer example in attached sheet)
(ii) Perform a calculation between dates starting at a date according to the start and end date (refer attached file) based on the above format in (i).

Thanks/David

[shg]

See attached.

[David Brown]

Thanks - you are a legend!