I need to include certain divs to short in a model given the time we short the stock. Here are the dates and divs: 10/29/2008_______$0.02 11/26/2008_______ $0.02 12/29/2008_______ $0.02 I think you need to have several IF stmts in the formula but need to include the necessary divs IF we buy them as of EX-DIV. I also have a cell that is ‘Today’s Date’ that will obviously be in the formula. Let me know if i’m not being clear… Thanks guys
HUH? What are you trying to do again? Trying to extract the date from that above format?