Hi jonmcmurray,
Commisserations!
Seems cancellations should take effect after the current billing period ?
This may or may not work for you, as I do not know what country you are making purchases from.
How to request a refund
- Go to reportaproblem.apple.com.
- Sign in with your Apple ID and password.
- If you see the "Report" or "Report a Problem" button next to the item that you want to request a refund for, click it.
- Follow the instructions on the page to choose the reason why you want a refund and submit your request.
Or
You might want to click on the "Get Support" link at the right on the top of this page to contact Apple.
Also
Apple support have articles online that may be helpful:
Check the status of a refund for apps or content that you bought from Apple
(Includes: When will I get the money back?).
https://support.apple.com/en-au/HT210904
Or
Request a refund for apps or content that you bought from Apple:
https://support.apple.com/en-au/HT204084
and
How long refunds from the App Store or other Apple services take:
https://support.apple.com/en-au/HT210904
Hope something here works for you :-)