So I just downloaded a list of historical closing prices from yahoo finance into excel and I would like ot match up this list with another trend line which is not stock related, however in order for them to match up on the same graph I need them to have the same date range. The trend line I get back from Yahoo Finance has just the weekdays becuase there are no stock prices on the weekends, so how do I quickly add the weekends to the list of weekdays? I have done this manually in th past and it is a pain in the a##. I usually just repeat the same stock price from Friday for both Saturday and Sunday to fill in the gaps. Anyone have a macro for this?? Thanks!