Column D has a list of the dates the market was open, column K has the market close on that date. I would like to find the value of the market close on, say, every 14th of the month. However, if the market is closed on the 14th (weekend, holiday, the week following 9/11, for example), I want the the value of the market close on the next day the market is open.
Example: 1/14/1928 was a Saturday, so I want the value on the next open day, which was Monday, 1/16/1928.
Example: 7/14/1977, a Thursday, the market was closed, but was opened on Friday 7/15/1977, so I want the value on that Friday.
Example: 9/14/2001 the market was closed. The next day the market was open was 9/17/2001, so I would like the value on that day.
How can I do this using formulas only, without using VBA?
Example: 1/14/1928 was a Saturday, so I want the value on the next open day, which was Monday, 1/16/1928.
Example: 7/14/1977, a Thursday, the market was closed, but was opened on Friday 7/15/1977, so I want the value on that Friday.
Example: 9/14/2001 the market was closed. The next day the market was open was 9/17/2001, so I would like the value on that day.
How can I do this using formulas only, without using VBA?