Qee zaum, cov xwm txheej yuav tsis raug teem rau hnub tshwj xeeb, tab sis raug khi rau ib hnub tshwj xeeb ntawm lub lim tiam ntawm ib hlis thiab xyoo - piv txwv li:
- thawj hnub Monday ntawm Lub Ib Hlis 2007 yog hnub Monday hnyav tshaj plaws ntawm lub xyoo
- Hnub Sunday thib ob hauv lub Plaub Hlis 2011 - Hnub Tiv Thaiv Huab Cua
- Thawj Hnub Sunday thaum Lub Kaum Hli 2012 – Xib Fwb Hnub
- thiab lwm yam
Txhawm rau txiav txim siab hnub tim uas ib hnub ntawm lub limtiam ntog, peb xav tau cov mis me me tab sis tsis yooj yim:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
nyob rau hauv lus Askiv version nws yuav
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
Thaum siv cov qauv no, nws xav tias
- B1 - xyoo (tus lej)
- B2 – tus lej hli (ntaus)
- B3 - tus naj npawb ntawm hnub ntawm lub lim tiam (Mon = 1, Tue = 2, thiab lwm yam)
- B4 - tus naj npawb ntawm hnub ntawm lub lim tiam koj xav tau
Rau ib qho tseem ceeb yooj yim thiab txhim kho cov qauv, ntau ua tsaug rau kev hwm zaum los ntawm peb lub Forum.
- Yuav ua li cas Excel khaws thiab ua cov hnub thiab sijhawm
- NeedDate muaj nuj nqi los ntawm PLEX add-on