using excel to determine what dates are missing prices

[michael]

Hi Mark,

I asked about a report to highlight missing prices on an investment.

I found this excel formula on the web that seems to do the trick and am posting it for others. It may be helpful

Attached is a pdf. The excel formula is at the bottom of the page.

Michael

[michael]

For some reason the Pdf didn't attach. Here's the link. The formula is at the bottom of the page.

http://www.mrexcel.com/forum/showthread.php?t=525685