鏄熸湡骞剧殑鑻辨枃绺锛?/h2>
mon,tu,wed,thur,fri,sat,sun. 鏄熸湡涓€锛歁on. 鏄熸湡浜岋細Tus. 鏄熸湡涓?Wed. 鏄熸湡鍥涳細Thur. 鏄熸湡浜旓細Fri. 鏄熸湡鍏細Sat. 鏄熸湡澶╋細Sun. 鍛靛懙锛屾垜鏄笓涓氶泤鎬濈殑锛屽揩瑕佹瘯涓氫簡.. 鎴戝彲鏄暀鎺堛€傘€?鏄熸湡涓€鍒版槦鏈熸棩鐨勮嫳鏂囨€庝箞鍐欙紵
鏄熸湡骞捐嫳鏂囧柈瀛楋紵
Seven days of the week锛屼竴鍛ㄤ腑鐨勪竷澶╋紝鏄熸湡涓€Monday锛屾槦鏈熶簩Tuesday锛屾槦鏈熶笁Wednesday锛屾槦鏈熷洓Thursday锛屾槦鏈熶簲Friday锛屾槦鏈熷叚Saturday锛屾槦鏈熸棩Sunday锛岃竟瀛﹁竟鍞憋紝璁板繂鍗曡瘝灏辨槸杩欎箞绠€鍗曘€?
sat鏄槦鏈熷咕锛?/h2>
鈶ユ槦鏈熷叚锛氬叏鍐橲aterday缂╁啓Sat. 鈶︽槦鏈熸棩锛氬叏鍐橲unday缂╁啓Sun. 鍊煎緱娉ㄦ剰鐨勬槸鍛ㄤ簩鍜屽懆鍥涘彇鍓嶅洓浣嶏紝鍏朵粬涓哄墠涓変綅銆?
鏃ユ湡鎬庨杭瀵?鑻辨枃锛?/h2>
瑕侀伩鍏嶈鏈冩渶绨″柈鐨勬柟寮忔槸鎶婃棩鏈熷畬鏁村鍑轰締銆?寰峰紡銆孌D-MM-YYYY銆嶏細9 Januar 2021. 鑻卞紡銆孌D-MM-YYYY銆嶏細 9 January 2021.
mar澶氬皯鏈堬紵
鏈堜唤绺鑻辨枃锛?鍓嶄笁瀛楁瘝灏辨悶瀹氾紒 涓€鏈?January JAN 涓夋湀 March MAR 鍥涙湀 April APR 浜旀湀 May MAY 鍏湀 June JUN 閭勬湁 7 鍒?/h2>
鏃ユ湡鎬庨杭瀵紵
鍙﹀锛屽湪浣跨敤鏁稿瓧鏍煎紡鏅傦紝鍙兘鏈冧互鍙ヨ櫉鎴栨敮铏熷彇浠f枩绶氳〃绀猴紝渚嬪锛?020 骞? 鏈?3 鏃ュ彲瀵垚13.7.2020 鎴?7-13-20銆?馃挕 瑁滃厖浠ユ暩瀛楄〃閬旀棩鏈熺殑鏍煎紡Year-Month-Day锛堝勾鈥?鏈堚€?鏃ワ級锛岃垑渚嬶細2020/07/13锛岀劇璜栧湪鑻卞紡鎴栫編寮忚嫳鏂囪!閮借純鐐哄皯瑕嬶紝涓昏鎳夌敤鍦ㄩ潪甯稿畼鏂规垨灏堟キ鐨勬枃浠朵腑銆?
jan 骞炬湀锛?/h2>
涓€鏈圝anuary锛圝an锛夈€佷簩鏈團ebruary锛團eb锛夈€佷笁鏈圡arch锛圡ar锛夈€佸洓鏈圓pril锛圓pr锛夈€佷簲鏈圡ay锛圡ay锛夈€佸叚鏈圝une锛圝un锛夈€佷竷鏈圝un锛圝ul锛夈€佸叓鏈圓ugust锛圓ug锛夌瓑銆?
jul鏄咕鏈堬紵
July锛堜竷鏈堬級锛欽uly 鍦ㄦ媺涓佽獮涓偤Iulius锛屼互鎱剁缇呴Μ澶у笣灏ゅ埄鐑忔柉路鍑辨拻鍛藉悕锛屼粬鍦ㄩ€欏€嬫湀鍑虹敓銆?
鏄熸湡骞?鑻辨枃 澶у锛?/h2>
鏄熸湡銆佹湀浠姐€佸亣鏃ャ€佹鍙蹭簨浠舵垨鏅傛湡蹇呴爤棣栧瓧姣嶅ぇ瀵?Day銆乵onth銆乭oliday绛夊瓧涓嶉爤棣栧瓧姣嶅ぇ瀵紝浣哅onday銆丮ay銆丒aster绛夊瓧闋堣棣栧瓧姣嶅ぇ瀵€?Example: The fourth Thursday of every November is Thanksgiving.
浠婂ぉ鏄熸湡骞?鑻辨枃鍟忓彞锛?/h2>
A锛?What day is today? = What day is it today?锛堜粖澶╂槦鏈熷咕锛燂級
excel鏄熸湡骞捐嫳鏂囷紵
鍏紡 鎻忚堪 =TEXT(TODAY(),”MM/DD/YY”) 浠M/DD/YY 鏍煎紡椤ず浠婂ぉ鐨勬棩鏈燂紝渚嬪銆?3/14/12銆?=TEXT(TODAY(),”DDDD”) 鏄熸湡骞撅紝渚嬪銆屾槦鏈熶竴銆?=TEXT(NOW(),”H:MM AM/PM”) 鐩墠鐨勬檪闁擄紝渚嬪銆?:29 PM銆?閭勬湁 8 鍒?
sep骞炬湀锛?/h2>
鍦ㄨ嫳鏂囦腑锛?鏈堬紙September锛夋簮鑷媺涓佽獮September锛屾剰鐐虹涓冨€嬫湀锛屽洜鍔犲叆1銆?鏈堣€屽緦绉伙紝鍦ㄦ湀鏇嗕笂鐨勭啊瀵偤Sep.鎴朣ept.銆?
鏄熸湡鍥涚殑鑻辨枃鏄粈楹硷紵
銆屾槦鏈熷洓銆嶇殑鑻辨枃鏄疶hursday锛屾湰缇╃偤Thor’s day锛堥浄绁炰箣鏃ワ級锛?璀嚜鎷変竵鏂囩殑Jovis dies(day of Jupiter””鏈ㄦ槦涔嬫棩””)锛屼篃灏辨槸銆屾湪鏇滄棩銆嶃€?/p>