Cov txheej txheem:

Siv Vintage Calendars: 12 Kauj Ruam
Siv Vintage Calendars: 12 Kauj Ruam

Video: Siv Vintage Calendars: 12 Kauj Ruam

Video: Siv Vintage Calendars: 12 Kauj Ruam
Video: tuav wb lub neej kom ruaj khov - Mang Vang ft. Christina Xyooj [Official Audio] 2021-22 2024, Kaum ib hlis
Anonim
Siv Vintage Calendars
Siv Vintage Calendars

Tsuas muaj 14 daim ntawv qhia hnub tshwj xeeb; cov lus qhia no yuav qhia koj yuav siv Excel li cas los ua cov npe ntawm daim ntawv qhia hnub xyoo, yog li koj tuaj yeem tso saib koj daim ntawv qhia hnub nyoog uas raug rau lub xyoo tam sim no. Koj tseem tuaj yeem siv cov txheej txheem no los tso saib daim ntawv qhia hnub nyoog yav tom ntej es tsis yog daim ntawv qhia hnub qub. Cov lus qhia tso tawm ntawm no ua haujlwm nrog ib qho tam sim no ntawm Excel, txawm hais tias cov lus qhia yuav ua raws siv Excel 2007. Cov lus qhia no tseem yuav qhia qee lub sijhawm txuag Excel cov lus qhia.

Kauj Ruam 1: Kaum plaub daim qhia hnub hli

Muaj kaum plaub yam qauv ua tau rau daim qhia hnub hli; cov npe hauv qab no qhia tag nrho cov xwm txheej uas tuaj yeem ua tau. Hom 1: Xyoo pib rau hnub Sunday, tab sis nws tsis yog xyoo leapType 2: Xyoo pib rau hnub Sunday, thiab nws yog xyoo leapType 3: Xyoo pib rau hnub Monday, tab sis nws tsis yog xyoo leapType 4: Xyoo pib rau hnub Monday, thiab nws yog xyoo leapType 5: Xyoo pib rau hnub Tuesday, tab sis nws tsis yog xyoo leapType 6: Xyoo pib rau hnub Tuesday, thiab nws yog xyoo leapType 7: Xyoo pib rau hnub Wednesday, tab sis nws tsis yog xyoo leapType 8: Xyoo pib rau hnub Wednesday, thiab nws yog xyoo leapType 9: Xyoo pib rau hnub Thursday, tab sis nws tsis yog xyoo leapType 10: Xyoo pib rau hnub Thursday, thiab nws yog xyoo leap Hom 11: Xyoo pib rau hnub Friday, tab sis nws tsis yog xyoo leapType 12: Xyoo pib rau hnub Friday, thiab nws yog xyoo leapType 13: Xyoo pib rau hnub Saturday, tab sis nws tsis yog xyoo leapType 14: Xyoo pib rau hnub Saturday, thiab nws yog xyoo leap

Kauj Ruam 2: Tsim Kab Ntawv Headers rau Koj Daim Ntawv Qhia Excel

Tsim Kab Ntawv Headers rau Koj Daim Ntawv Qhia Excel
Tsim Kab Ntawv Headers rau Koj Daim Ntawv Qhia Excel

Hauv koj daim ntawv Excel, sau cov cell raws li hauv qab no: Cell A1: StartCell B1: DOWCell C1: Hnub (Hnub = 1) Cell D1: Leap? Cell E1: TypeCell F1: Xyoo

Kauj Ruam 3: Tsim Cov Npe Hnub Xyoo Tshiab

Tsim Cov Npe Hnub Xyoo Tshiab
Tsim Cov Npe Hnub Xyoo Tshiab

Hauv cell A2, sau hnub tim 1/1/1901. Excel muaj kab uas tsis raug xav tias 1900 yog xyoo leap, yog li tsis txhob pib ua ntej xyoo 1901. Txoj cai rau xyoo leap yog qhov yooj yim: Xyoo yuav tsum tau faib sib npaug los ntawm 4, tshwj tsis yog lub xyoo xaus hauv 00 qhov xwm txheej twg xyoo kuj yuav tsum sib npaug sib npaug ntawm 400. Yog li, 1900 tsis yog xyoo dhau mus, tab sis 2000 yog nyob hauv cell A3, sau hnub tim 1/1/1902. Tuav koj sab laug nas, thiab xaiv cov cell A2 thiab A3. Koj yuav pom tias nyob rau sab qis-sab xis ntawm kev xaiv muaj lub thawv dub me me; tuav koj tus nas khawm sab laug, xaiv lub thawv dub me me thiab rub qis (thaum koj tus nas hovering hla qhov chaw raug, nws yuav tig mus rau 'kos npe ntxiv'). Thaum koj rub qis, koj yuav pom tias hnub tim yuav tshwm. Luag nqes mus txog thaum koj mus txog rau 1/1/2036 thiab tso lub khawm nas sab laug. Tias yog thaum kuv tuaj yeem so haujlwm, muab kev lag luam tam sim no!

Kauj Ruam 4: Zaub Hnub ntawm Lub Limtiam

Zaub Hnub ntawm Lub Limtiam
Zaub Hnub ntawm Lub Limtiam
Zaub Hnub ntawm Lub Limtiam
Zaub Hnub ntawm Lub Limtiam

Hauv cell B2, nkag mus = A2. Qhov no yuav qhia 1/1/1901. Tom qab ntawd nrog tus cursor tseem nyob hauv cell B2 xaiv Hom Ntawv, Format Cells, xaiv Custom, thiab hauv Hom: teb sau dddd. Qhov no tsim cov txheej txheem tus lej rau hnub uas qhia hnub ntev ntawm lub lim tiam.

Kauj Ruam 5: Qhia Hnub Zej Zog ntawm Lub Limtiam

Zaub Numeric Hnub ntawm Lub Limtiam
Zaub Numeric Hnub ntawm Lub Limtiam

Hauv cell C2, sau cov mis = WEEKDAY (A2) thiab nias nkag mus. WEEKDAY ua haujlwm rov qab tus lej rau hnub ntawm lub lim tiam. Los ntawm kev nkag mus rau txoj haujlwm no, Hnub Sunday = 1, Hnub Monday = 2, thiab lwm yam. Txij li 1/1/1901 yog hnub Tuesday, qhov sib npaug rov qab los 3.

Kauj Ruam 6: Txiav txim seb Puas Yog Xyoo Muab Yog Xyoo Leap

Hauv xov tooj ntawm tes D2, peb tab tom yuav nkag mus rau cov qauv sib luag kom paub tseeb tias lub xyoo yog xyoo dhau los lossis tsis yog. Txij li qhov sib npaug yog qhov ncaj ncees, kuv yuav qhia nws hauv qab no thiab tom qab ntawd piav qhia nws ua li cas nws ua. Nov yog qhov sib npaug (nkag mus raws nraim raws li qhia hauv cell D2): = YOG (LOS YOG (MOD (YEAR (A2), 400) = 0, THIAB (MOD (YEAR (A2), 4) = 0, MOD (YEAR (A2), A2)), 100) 0)), "Leap", "") MOD luv luv rau cov qauv, uas yog cov lej sib faib uas tuaj yeem faib tau yam tsis muaj qhov seem ntawm qhov sib txawv ntawm ob qho ntxiv. Piv txwv li, 2 yog tus qauv ntawm 5 thiab 9. Qhov LOS YOG hauv qhov kev ntsuas zauv rau peb yam xwm txheej, ob qho ntawm (THIAB) yuav tsum tshwm sim ua ke: Xyoo nyob hauv xov tooj ntawm tes A2, thaum faib los ntawm 400, yog tus lej tag nrho (piv txwv li seem = 0) Nov yog THIAB (ob qho xwm txheej hauv qab no yuav tsum tshwm sim): Xyoo hauv cell A2, thaum faib los ntawm 4, yog tus lej tag nrho (piv txwv li qhov seem = 0) Xyoo hauv cell A2, thaum faib los ntawm 100, yog tsis yog tus lej tag nrho (piv txwv li seem 0) Yog tias thawj ntawm peb qhov xwm txheej tau ntsib LOS YOG ob qho ntawm ob qhov xwm txheej tom ntej tau ntsib, tom qab ntawv cov mis rov qab lo lus Leap. Txwv tsis pub, cov txiaj ntsig tau tshwm sim hauv qhov khoob (uas yog ""). Thaum koj nias nkag mus, koj yuav tsis pom dab tsi vim tias xyoo 1901 tsis yog xyoo leap.

Kauj Ruam 7: Muab Lub Xyoo

Zaub Xyoo
Zaub Xyoo

Hla hla cell E2 (peb yuav sau qhov ntawd tom qab). Hauv cell F2, nkag mus rau qhov sib npaug = YEAR (A2). Qhov no yuav rub tsuas yog xyoo tawm ntawm hnub tim. Thaum koj nias nkag mus rau ntawm tes yuav tsum hais 1901.

Kauj Ruam 8: Luam Txhua Cov Qauv

Luam tag nrho Cov Qauv
Luam tag nrho Cov Qauv
Luam tag nrho Cov Qauv
Luam tag nrho Cov Qauv

Highlight cells B2 mus txog F2. Koj yuav pom tias nyob rau sab qis-sab xis ntawm kev xaiv muaj lub thawv dub me me; tuav koj tus nas khawm sab laug, xaiv lub thawv dub me me thiab luag nqis (thaum koj tus nas hoverer hla qhov chaw raug, nws yuav tig mus rau 'kos npe ntxiv'). Thaum koj rub qis, koj yuav pom tias hnub yuav tshwm. Luag nqes mus txog thaum koj mus txog 1/1/2036 thiab tso lub pob nas sab laug. Thaum koj tso tus nas khawm, txhua tus qauv uas koj tau sau yuav raug theej rau hauv qab ntawm daim ntawv nthuav qhia. Koj pom qee xyoo sau tias Leap. Cov ntawd yog cov leap xyoo.

Kauj Ruam 9: Hloov Cov Qauv rau Qhov Muaj Peev Xwm

Hauv cov kauj ruam no, peb yuav hloov tag nrho peb cov qauv rau qhov muaj nuj nqis. Qhov koj tus cursor mus rau cell A2. Tuav tus yuam sij ua haujlwm, coj mus rhaub qhov kawg ces coj mus rau xub xub. Tsis txhob tso tus yuam sij ua haujlwm. Tam sim no koj yuav tsum muaj tag nrho cov hnub (nqes mus rau 1/1/2036) tseem ceeb. Thaum tseem tseem tuav tus yuam sij Hloov, nias lub xub xub tsib zaug. Tam sim no koj yuav tsum muaj cov hlwb A2 txog F137 tau hais tseg. Txoj cai-nas hauv thaj chaw tseem ceeb. Tus ciam teb yuav tsum hloov mus rau txoj kab dotted. Xaiv Luam los ntawm cov ntawv qhia luv. Tom qab ntawd, txoj cai nas dua, tab sis lub sijhawm no xaiv Muab Tshwj Xeeb, nyem rau ntawm qhov tseem ceeb xov tooj cua khawm, thiab xaiv OK. Txheeb xyuas txhua lub xovtooj uas muaj tus qauv (zoo li C2 lossis F2); cov mis yuav tsum tau hloov los ntawm cov txiaj ntsig cov txiaj ntsig.

Kauj Ruam 10: Txheeb Hom Hom Xyoo Ua Ke

Sort Xyoo Hom Ua Ke
Sort Xyoo Hom Ua Ke
Sort Xyoo Hom Ua Ke
Sort Xyoo Hom Ua Ke

Txav koj tus cursor mus rau cell A2. Xaiv Sort & Filter, tom qab ntawd xaiv Custom Sort. Sort by the Day (Sun = 1) thiab Leap? kab. Nyem OK. Koj cov ntaub ntawv yuav raug txheeb kom txhua yam ntawm Hom 1 (lub lim tiam pib rau hnub Sunday, tsis yog xyoo leap) yog ua ke, thiab lwm yam.

Kauj Ruam 11: Txheeb Xyoo Raws Li Hom Xyoo

Txheeb Xyuas Xyoo Raws Li Hom Xyoo
Txheeb Xyuas Xyoo Raws Li Hom Xyoo
Txheeb Xyuas Xyoo Raws Li Hom Xyoo
Txheeb Xyuas Xyoo Raws Li Hom Xyoo

Txav koj tus cursor mus rau cell E2. Nkag mus rau tus lej rau hom daim ntawv qhia hnub los ntawm Kauj Ruam 1 mus txog txhua hnub hauv daim ntawv teev npe. Cov npe tau rov ua dua hauv qab no ib yam nkaus. Hom 1: Xyoo pib rau hnub Sunday, tab sis nws tsis yog xyoo leapType 2: Xyoo pib hnub Sunday, thiab nws yog xyoo leapType 3: Xyoo pib rau hnub Monday, tab sis nws tsis yog xyoo leapType 4: Xyoo pib hnub Monday, thiab nws yog xyoo leapType 5: Xyoo pib rau hnub Tuesday, tab sis nws tsis yog xyoo leapType 6: Xyoo pib rau hnub Tuesday, thiab nws yog xyoo leapType 7: Xyoo pib rau hnub Wednesday, tab sis nws tsis yog xyoo leapType 8: Xyoo pib hnub Wednesday, thiab nws yog xyoo leapType 9: Xyoo pib rau hnub Thursday, tab sis nws tsis yog xyoo leapType 10: Xyoo pib rau hnub Thursday, thiab nws yog xyoo leap Hom 11: Xyoo pib rau hnub Friday, tab sis nws tsis yog xyoo leapType 12: Xyoo pib rau hnub Friday, thiab nws yog xyoo leapType 13: Xyoo pib rau hnub Saturday, tab sis nws tsis yog xyoo leapType 14: Xyoo pib rau hnub Saturday, thiab nws yog xyoo leap

Kauj Ruam 12: Nrhiav Daim Ntawv Teev Npe

Nrhiav daim qhia hnub hli
Nrhiav daim qhia hnub hli
Nrhiav daim qhia hnub hli
Nrhiav daim qhia hnub hli

Txhawm rau nrhiav lub xyoo tshwj xeeb, nias CTRL F ntawm koj cov keyboard, thiab tshawb rau xyoo. Piv txwv li, 2009 yog daim ntawv qhia hnub nyoog 5. Qhov ntawd txhais tau tias koj tuaj yeem siv daim ntawv qhia hnub nyoog los ntawm ib xyoos twg ntawm tib hom (1903, 1914, 1925, 1931, 1942, 1953, 1959, 1970, 1981, 1987, 1998, 2009, 2015, lossis 2026) thiab nws yuav zoo ib yam rau xyoo no daim ntawv qhia hnub. Qhov txawv txaus, qhov no yog lub xyoo yug tseem ceeb rau kuv, thiab xyoo no daim ntawv qhia hnub zoo ib yam rau xyoo uas kuv tau yug los. Kuv tso nws li kev tawm dag zog rau tus tub ntxhais kawm txhawm rau txiav txim siab tias kuv muaj hnub nyoog li cas. Txaus siab rau!

Pom zoo: