Consulting

Results 1 to 6 of 6

Thread: Put NA on cells with dates before indicated start week

  1. #1
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location

    Put NA on cells with dates before indicated start week

    Hello, the attached file shows which weeks each client has data on raw sheet. However my def&calc sheet has start and end week columns.
    What I am trying to do is put NA on weeks before the indicated start week, N on weeks with no data and Y on weeks with data.
    Then on the indicated week start date will either be N or Y depending on whether they have data on raw sheet or not.
    Also if there's a week end date all weeks after the week end date will be NA.
    If the week start and end dates are empty it should carry on with putting Y or N depending on whether they have data or not in raw sheet
    My code only does the Y and N. I don't know how to do the NA part.

    Also, the NA weeks won't be part of the averaging, just the Y and N

    Please help thank you
    Attached Files Attached Files
    Last edited by jazz2409; 06-18-2020 at 11:05 AM. Reason: additional info

  2. #2
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    anyone?

  3. #3
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    Anyone?

  4. #4
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    Any help is appreciated.

  5. #5
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    Anyone?

  6. #6
    VBAX Tutor
    Joined
    Jan 2020
    Posts
    204
    Location
    Hello??????

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •