ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Ãö©óÄæ¦ìÀx¦s®æ¤é´Á

Ãö©óÄæ¦ìÀx¦s®æ¤é´Á

§Ú·Q­nªº¤é´Á®æ¦¡¬O
1.2015/9/1
2.2015/9/10
3.2015/10/1
4.2015/10/10

§ÚÀx¦s®æ¤é´Á³£¬O
20150901
20150910
20151001
20151010

¥H¤W¥u¬OÁ|¨Ò¡A¦³«Ü¦h¦C...¦³¤°»ò¤è¦¡¥i¥H¸Ñ¨M

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-3 11:42 ½s¿è

¦^´_ 1# EGBT
°²³]¸ê®Æ²Ä¤@µ§¦ì©óÀx¦s®æA1
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

½Ð°Ý¼Ó¤W¤j¤j³o¬O¨ç¼ÆÁÙ¬OVBA?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-3 11:46 ½s¿è

¦^´_ 3# EGBT
¬O¨ç¼Æ¡A¶È´N°ÝÃD1#´y­z¸Ñ¡C
¤£²Å±z»Ý¨D¡H

TOP

¦ý¬O¨ç¼Æ®æ¤l¸Ì­±¤w¸g¦³¥´¤é´Á¡G20150901

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-3 11:49 ½s¿è

¦^´_ 5# EGBT
¡u20150901¡v¬O¼Æ¦r©Î¤å¦r®æ¦¡
±z¤£¬O­n¤é´Á®æ¦¡¡uyyyy/mm/dd¡v¡H
ÁÙ¬O·|¿ù·N¤F¡HSorry¡I

TOP

¼Ó¤W¤j¤j§A¦n
§Aªºµª®×§¹¥þ¥¿¸Ñ
¬O¤p§Ì·|¿ù·N¤F
­è­è¨S¿ìªk¯d¨¥

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD