+ Reply to Thread
Results 1 to 7 of 7

Put NA on week dates IN RANGE

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Exclamation Put NA on week dates IN RANGE

    Hi, so this is kind of like this https://www.excelforum.com/excel-pro...-in-range.html

    But slightly different. This time, I added a new sheet called Special Considerations where I need to check the dates that the people did not send data. The projects, client names and types will have multiple entries over time. I need to be able to check the dates and put NA on dates that they did not send data based on Project Name, Client Name, and Type. If the specific Project and Client and Type has an entry in the Special Considerations sheet and they have no data in the raw sheet, the week(s) will be tagged as NA. If they have no entry in the Special Considerations sheet and they have no data in raw sheet, they will be tagged as N. If they have data, they will be tagged as Y.

    The attached file shows the current output of my macro (current sheet) and the should be sheet shows what the output should be.

    Please help
    Attached Files Attached Files
    Last edited by homerl2409; 07-21-2020 at 07:33 AM.

  2. #2
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Re: Put NA on week dates IN RANGE

    anyone?

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,135

    Re: Put NA on week dates IN RANGE

    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  4. #4
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Re: Put NA on week dates IN RANGE

    Quote Originally Posted by Pepe Le Mokko View Post
    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Sorry I didn't mean it that way

  5. #5
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Re: Put NA on week dates IN RANGE

    Any help is appreciated

  6. #6
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Re: Put NA on week dates IN RANGE

    Anyone?

  7. #7
    Registered User
    Join Date
    12-06-2019
    Location
    us
    MS-Off Ver
    office 365
    Posts
    18

    Re: Put NA on week dates IN RANGE

    hmm Anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Put NA on week dates not in range
    By homerl2409 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2020, 04:38 AM
  2. [SOLVED] Count Week number from range of dates
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2018, 11:42 PM
  3. If statements to check range for dates within current month, week and quarterly.
    By trying-my-best in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2017, 02:55 PM
  4. [SOLVED] Return value (Week number) if date is within a range of dates
    By bmunoz64 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2015, 08:11 AM
  5. [SOLVED] Return date of Friday of each week from a range of dates
    By emortals in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2015, 12:29 PM
  6. [SOLVED] Counting how many dates in a range fall into this week and last week
    By AneelK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2013, 09:38 AM
  7. Finding all dates in a column that are in the range today to a week from now
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-01-2008, 09:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1