View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TraderXL TraderXL is offline
external usenet poster
 
Posts: 1
Default formula to lookup data in cell NEXT to another cell

I have downloaded some historical quotes for MSFT in one spreadsheet. IN
another sheet I want to write a formula to say find June 19, 2009 and look
for the previous TRADING DAY (not previous day, which could be a weekend
day). How do I do that?