Skip to content

Instantly share code, notes, and snippets.

Thiết lập:
A1=2020
AN1="SUN" hoặc "MON"
Tác giả: T.D.Nguyen
Rút gọn: N.D.Thanh
=ArrayFormula({
{"\/";TEXT(DATE(A1,ROW(1:12),1),"mmmm")}
,{
UPPER(TEXT("1/1/2018"+COLUMN($A$1:$AP$1)-(1+(AN1=TEXT(DATE(2017,1,1),"ddd"))),"DDD"));