Results 1 to 2 of 2

Check if date exists in Named Range "Holiday_List"

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Check if date exists in Named Range "Holiday_List"

    In my Workbook_BeforeSave
    I am looping through a range (T2:AM50) looking for bad entries (Weekends and Holidays).
    All these entries are dates (or empty).

    To check for Weekends, I have used:
    If Not (IsEmpty(cel)) Then 
        If Weekday(cel) = 1 Or Weekday(cel) = 7 Then BadCount = BadCount + 1
    BUT I need to compare against the NamedRange "Holiday_List" also.

    Additionally, I'd like "Holiday_List" to span more than 2 columns but can subdivide into two lists if necessary.


    I know there is a Networkdays option, but cannot figure out how to apply as there is no Start/End Date there are just dates entered randomly into the cells in T2:AM50.
    Last edited by carsto; 01-09-2012 at 02:34 PM. Reason: solved

Thread Information

Users Browsing this Thread

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

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