View Single Post
 
Old 02-15-2016, 01:41 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Please forget my previous post.

Use the following array formula instead:

=INDEX(D213,MATCH(1,((A2:A13>=DATE(YEAR(E2),MONT H(E2),1))*(B2:B13<=DATE(YEAR(E2),MONTH(E2)+1,0))), 0))

(Must be entered by holding down Ctrl and Shift before pressing Enter).


(Anyone who knows how to avoid the Big Grin icon when one enters for example D2 colon D13?)
Reply With Quote