エクセル関数メモ


いつもその都度しらべてるので、メモ的な

今日の日付をYYYYMMDD

文字列結合内で使いたいとかに

=YEAR(TODAY())&IF(MONTH(TODAY())<10,"0"&MONTH(TODAY()),MONTH(TODAY()))&IF(DAY(TODAY())<10,"0"&DAY(TODAY()),DAY(TODAY()))