- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
·Q¤F¦n¤[²×©ó¸Ñ¥X¨Ó¤F¡A¤À¨É¤@¤U
=IF(TEXT(RIGHT(A1,2),"00")="12",TEXT(LEFT(A1,3)+1,"000")&"/"&TEXT(RIGHT(A1,2)-11,"00"),TEXT(LEFT(A1,3),"000")&"/"&TEXT(RIGHT(A1,2)+1,"00"))
¦p¦¹¤@¨Ó´N¥i¥H¤@ª½¥¿½Tªº©µÄò¤U¥h¤F |
|