Excel 如何去掉日期年,月,日中的年月只留日

2025-01-08 04:38:47
推荐回答(2个)
回答1:

=day(日期)
=day(a1)

回答2:

=SUBSITTURE(SUBSITTURE(单元格,"年",""),"月","")