(Read More: Prince Harry—UK Business Ambassador?)
In September 2012, the prince returned to Afghanistan and undertook an operational tour as an Apache Pilot. In a statement on Friday, Lieutenant Colonel Tom de la Rue, who commanded Prince Harry in the Army Air Corps, said the prince had reached the "pinnacle of flying excellence" as an Apache pilot, particularly in Afghanistan.
"(He) has proved to be a real inspiration to the many Army Air Corps officers and soldiers who have come to know him so well over the last two years," de la Rue said.
As well as the announcement that he has completed his attachment, Kensington Palace confirmed to CNBC that the prince would be concentrating on trying to bring the Warrior Games -- an Olympic-style sporting event for ill and injured service members and veterans -- to London.
(Read More: Princes William and Harry hit the trading floor)
In May 2013, the competition took place in Colorado with more than 200 participants competing in seven sports including archery, cycling, shooting, sitting volleyball, swimming, track and field and wheelchair basketball.
A spokesperson for Kensington Palace said that "detailed feasibility work" was being undertaken on behalf of the Royal Foundation and the Ministry of Defence on concepts and funding for the U.K. to host an inaugural International Warrior Games later this year, using the Olympic venues in Stratford, London for the event.
"A final recommendation will be made at the end of January," the spokesperson said. "Prince Harry was hugely impressed by the Warrior Games, which he visited in the United States in May last year. He said then he would be keen to see it brought to the U.K. and would do what he could to help."
Meanwhile, there was more news from the U.K.'s royal family on Friday. Zara Phillips - the daughter of Princess Anne and an Olympic silver medalist - has given birth. The new baby girl is the British Queen's fourth great-grandchild, but will not bear a royal title and the name has yet to be confirmed.
By CNBC.com's Matt Clinch. Follow him on Twitter