Results 1 to 3 of 3
  1. #1
    Hall-Of-Famer
    Points: 65,231, Level: 79
    Level completed: 24%, Points required for next Level: 1,219
    Overall activity: 1.0%
    Achievements:
    SocialVeteran50000 Experience Points
    Cyclonesrule91's Avatar
    Join Date
    Apr 2006
    Location
    Waukee
    Posts
    4,949
    Points
    65,231
    Level
    79
    Thumbs Up
    Received: 15
    Given: 121

    Excel question number 5....

    I have posted questions on needing help setting up a spreadsheet before and have gotten the help I needed every time. So I need help again and hoping somebody can help.

    I am building a spreadsheet where I am trying to make a list of trading days in a range of dates. My current range is from 3/30/11 thru 11/25/11. I want to be able to make a list of the dates in that range excluding Saturdays, Sundays and a few holidays that are in there. I used the NETWORKDAYS() function to tell me there are 168 trading days but I want to make a list of the dates and then a column right beside it showing the trading day number from 1-168.

    Anyone know of an easy way to make that work?

    Thank you in advance



  2. #2
    Hall-Of-Famer
    Points: 84,703, Level: 90
    Level completed: 53%, Points required for next Level: 847
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience PointsCreated Album pictures
    azepp's Avatar
    Join Date
    Dec 2009
    Location
    Ankeny
    Posts
    3,964
    Points
    84,703
    Level
    90
    Thumbs Up
    Received: 183
    Given: 128

    Re: Excel question number 5....

    Start with 3/30/11 in A1. In A2 use '=WORKDAY(A1,1)'. Fill down until you get to your desired end date.


    To exclude holidays, complete a separate range with each holiday listed and enter the range as the third variable in the above equation.



  3. #3
    Hall-Of-Famer
    Points: 65,231, Level: 79
    Level completed: 24%, Points required for next Level: 1,219
    Overall activity: 1.0%
    Achievements:
    SocialVeteran50000 Experience Points
    Cyclonesrule91's Avatar
    Join Date
    Apr 2006
    Location
    Waukee
    Posts
    4,949
    Points
    65,231
    Level
    79
    Thumbs Up
    Received: 15
    Given: 121

    Re: Excel question number 5....

    Thank you azepp!!!!



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: FS1
  • Iowa State vs. Oklahoma
  • November 1, 2014
  • 11:00 AM