I'm sorry if you already have this information. His ship actually hit a mine rather than was bombed. This was several weeks after the D Day landings.
He was an able-seaman on a destroyer. When it sank, 11 officers and 143 ratings were lost. There were only 20 survivors. The wreck lies in the channel, seven and a half miles north of the French village of Arromanches-les-Bains (about half way between Le Havre and Cherbourg).
I take it that you have some details of his service, if not - as others have already said - you can apply to the National Archives to see his service records, although there is a charge for this.
I'm not sure when he joined the destroyer. There is a record of a person of the same name and same date of birth joining the navy on 17 July 1941 and then being posted to a submarine training flotilla with a rating of Sto ii (Stoker 2nd Class) on 21 November 1941.
It looks like he wasn't successful, as his record says that he failed submarine training on 16 January 1942.
I would guess that it was some time after that, that he was transferred to the destroyer.
The destroyer saw action all over the place during the early years of the war. It was then badly damaged by Japanese air raids in Singapore in early 1942 and was towed to Bombay for repair.
It was then re-commissioned for service in the Mediterranean on 17 January 1943.
So it may be that he may have been stationed at various places during 1942, after his submarine training, and then to the destroyer when it was re-commissioned in 1943. (If you get his records, that will tell you definitvely where he was stationed.
During 1943 and early 1944, the destroyer undertook various missions in the Mediterranean, such as convoy defence (on one occasion it sank a German U boat) and supported Allied landings on Sicily and Anzio.
During the D Day operations the destroyer carried troops of the Durham Light Infantry who were intending to attack one of the beaches.
After that, the destroyer was engaged against some German torpedo boats.
After this, they had five days leave in Portsmouth from 12th to 17th July. So he likely had chance to go back home and see his family at this time.
Then, of course, it sank on the 20th.
Here is a photo of the destroyer (it is the one in the front