=TEXT(B2,"e.m.d")&C2&TEXT(D2,"e.m.d")“至”的那一列也可以不用，直接用：=TEXT(B2,"e.m.d")&"至"&TEXT(C2,"e.m.d")
写代码来批量实现！
