More than 1 year has passed since last update.

【VBA】条件付き書式ガントチャート進捗変化

Excel

Last updated at 2022-09-07Posted at 2022-09-06

=CONCATENATE("=AND($",F9,F10,"-WEEKDAY($",F9,F10,",3)<=",C9,"$",C10,",",C9,"$",C10,"<=($",F9,F10,"-WEEKDAY($",F9,F10,",3)-7)+ROUNDDOWN((($",E9,E10,"-WEEKDAY($",E9,E10,",3)+6)-($",F9,F10,"-WEEKDAY($",F9,F10,",","3))+1)*$",G9,G10,",0))")

確認用

'=AND($B5-WEEKDAY($B5,3)<=B$2,B$2<=($B5-WEEKDAY($B5,3)-7)+ROUNDDOWN((($C5-WEEKDAY($C5,3)+6)-($B5-WEEKDAY($B5,3))+1)*$D5,0))

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up