Formula for number sequence with text

[Nashraze]

Hi ,
Please anybody help excel formula for number sequence for example RFI/HCO/PL/0001/2020 i need continuous next number ie ; RFI/HCO/PL/0002/2020 no need to change year

attached excel sheet for your reference

 

[Fluff13]

How about
=REPLACE(A4,12,4,TEXT(MID(A4,12,4)+1,"0000"))