+ Reply to Thread
Results 1 to 3 of 3

I'm trying to insert weekend and holiday dates into a long term data series

  1. #1
    Registered User
    Join Date
    06-08-2020
    Location
    San Diego, California
    MS-Off Ver
    Office 2016 desktop
    Posts
    2

    Lightbulb I'm trying to insert weekend and holiday dates into a long term data series

    Hi all, and thanks in advance for any suggestions on my question. I have a column of dates and historical market data that shows trading days only (weekdays). I would like to insert weekend and holiday dates into this data series. It is many decades of data so very time consuming to do manually. Any suggestions would be greatly appreciated.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: I'm trying to insert weekend and holiday dates into a long term data series

    1) Create a new blank table with all the dates in the first column. Put in the first two dates, then drag down as far as needed until you have a complete list of dates.

    2) Now use VLOOKUP formulas in the next column to look up the dates in the original data and bring over the matching info.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    06-08-2020
    Location
    San Diego, California
    MS-Off Ver
    Office 2016 desktop
    Posts
    2

    Re: I'm trying to insert weekend and holiday dates into a long term data series

    Fantastic! I'll try that. Thank you very much!

+ 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. Long term data into single column
    By chsaleem in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-08-2018, 03:39 AM
  2. Replies: 3
    Last Post: 08-13-2018, 04:51 PM
  3. [SOLVED] How many WEEKEND DAYS & HOLIDAY DAYS between 2 dates in September
    By leovfx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2017, 07:32 PM
  4. [SOLVED] Long Weekend Formula for Holiday
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-27-2015, 04:30 AM
  5. Calculating short term and long term moving average in VBA
    By ixthus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2013, 02:40 AM
  6. Dealing with a long-term measurement data
    By Excelmania013 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-06-2013, 04:54 AM
  7. RE: Need term for data series
    By Gary''s Student in forum Excel General
    Replies: 0
    Last Post: 08-22-2006, 07:25 PM

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