This question already has an answer here:
John 14:16 says:
And I will pray to God that he will send to you another comforter, who will abide with you for ever!
Muslims claim that "another comforter" means Ahmad in Arabic, which means "Praised One"; and Muhammad also means "Praise One" hence, Ahmad and Muhammad are synonyms (same meaning).
Hence John 14:16 talks about prophet Muhammad of Islam!
As per me, names given to humans by their elders don't necessary reflect the attributes of that particular human. For example, Shah-Rukh Khan, the superstar of Indian films was named Shah-Rukh by his elders (parents). Shah means king, Rukh means face. Hence, Shah-Rukh means face of the king! But, it doesn't mean that actor Shah-Rukh Khan is the King of some country.
Similarly, Muhammad was so named by his grandfather Abdul-Muttalib. It is his original name. But Ahmad is not the original name of prophet Muhammad. Ahmad is an attribute of prophet Muhammad.
Just like Rashid (guided one), Bashir (bringer of good tidings), Rasul (messenger), Nabi (prophet), Mustafa (chosen one) are attributes of the prophet Muhammad, not original-names. The original name of the prophet Muhammad is Muhammad only, name given by his grandfather.
This is the difference between Muhammad and Ahmad.
But sura 61 verse 6 in the Quran, in a nutshell, says:
Jesus told the children of Israel that, after him, a messenger will come whose name will be Ahmad.
Name in Arabic means "bisma, us muha, I-sma".
Sura 61, verse 6 should have said "a messenger will come after me who will be Ahmad" instead of "whose name will be Ahmad".
in sura 61 verse 6 , "AHMAD" is NOUN (name of a person ) instead of ADJECTIVE ( attribute of the person ) which is exactly opposite to John 14:16 in which PARCLETE -COMFORTER-PRAISED-ONE or AHMAD is ADJECTIVE instead of NOUN
As I explained before, there is a vast difference between formal, official names and attributes, which are taken as names of the concerned human. Muhammad is the former (official name) of the prophet, and Ahmad is the attribute of the prophet, assumed as a name of the prophet.
Or John 14:16 should have said: "and I will pray to God that he will send another comforter whose name will be Praised One or Comforter or Counselor" (Ahmad in Arabic) instead of "and I will pray to God that he will send another comforter".
I would like to understand if John 14:16 really talks about prophet Muhammad.