Conditional Array Formula for date
I am trying to display all the dates for a particular month from a list. The
data is accumulated on the Log sheet and is pulled to the Monthly Log sheet
based on a dropdown.
=INDEX(Log!$A$1:$O$2000,SMALL(IF((Log!$B$1:$B$2000 <($Q$1),
Log!$b$1:$b$2000($Q$2)),ROW(Log!$A$1:$O$2000)),RO W(Log!2:2)),1)
where
q1 is beginning of month
q2 is end of month
How do I set this formula to just pull dates from the month displayed in the
dropdown.
(I hope this makes sense.)
|