Hello excel community, please find the attached sheet and help. With thanks
U Ufoo Member Aug 6, 2019 #1 Hello excel community, please find the attached sheet and help. With thanks Attachments WORK PLAN chn.xls 27.5 KB · Views: 5
Hui Excel Ninja Staff member Aug 6, 2019 #2 First, I'd go away fr5om Week Numbers to dates. Why what happens to the dates like 30 August? Second, E4: =IF(AND($C4<=F$3,$D4>E$3),$B4,"") Third: Fix up the Month Tiles, to align with the months better See attached Attachments WORK PLAN chn (IH).xls 48.5 KB · Views: 4 1565104146248.png 48.6 KB · Views: 3
First, I'd go away fr5om Week Numbers to dates. Why what happens to the dates like 30 August? Second, E4: =IF(AND($C4<=F$3,$D4>E$3),$B4,"") Third: Fix up the Month Tiles, to align with the months better See attached