LoginSignup
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

@96sapbasis(Kota Kurokawa)

簡易勤怠表エクセル作成。平日のみ表示/週毎に色変更

Posted at

成果物

image.png

＃作成方法
黄色の付箋は名前入力
日付はユーザ定義：m/d(aaa)
C3セルは直接日付入力：2025/3/3
D3以降：=WORKDAY(C3,1)入力後、右にドラッグ
色付け：日付のみ選択、条件付き書式設定→数式入力=MOD(WEEKNUM(C3),2)=0、書式の色変更

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?