MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula!!!! - Day of last market close

Posted by Super-T on December 10, 2001 8:14 PM


Posted by IML on December 11, 2001 6:39 AM



where the timevalue is provided to allow users to easily change the local stock market closing time.

Posted by IML on December 14, 2001 2:55 PM

spelling and formula error

okay Boolean and both formula provide the incorrect answer on weekends after market close

I believe

addresses this with the holiday being the named range for holidays.