• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic formula again.

Hui

Excel Ninja
Staff member
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

61945

See attached
 

Attachments

Top