Fans Tech
Friday, July 24, 2009
excel 自動曜日計算と色分け
A2セルの値によって、自動曜日計算
=IF(A2="","",CHOOSE(WEEKDAY(A2), "日", "月", "火", "水", "木", "金", "土"))
そして条件付書式で色分けできる。
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment