=IF(REGEXMATCH(A1,"昭和"), REGEXEXTRACT(A1,"[0-9]+")+1925, IF(REGEXMATCH(A1,"平成"), REGEXEXTRACT(A1,"[0-9]+")+1988,"一致なし"))

External CSS

This Pen doesn't use any external CSS resources.

External JavaScript

This Pen doesn't use any external JavaScript resources.