Skip to content

Instantly share code, notes, and snippets.

@NonAbility

NonAbility/Table_Name_4.md

Last active March 12, 2024 10:31
Show Gist options
  • Save NonAbility/cc35a809d3fa5d0f7748b25d0d47c215 to your computer and use it in GitHub Desktop.
Save NonAbility/cc35a809d3fa5d0f7748b25d0d47c215 to your computer and use it in GitHub Desktop.
Download ZIP
名前定義：R_YMD
Raw
Table_Name_4.md
定義名 数式 備考
R_YMD =TEXT(
DATE(
YEAR(R_YM),
MONTH(R_YM),
IF($B$3="All","1",VALUE($B$3))
),
"YYYY年m月d日 (aaa)"
)		 曜日付の西暦年月日を関数で文字列化しているので、
セルの表示形式は標準のまま。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment