Hi Mr. Excel,
I would like to seek for assistance on how to get the array date in between. Example below:
=SUMPRODUCT(--(A2:B2=myWeekend))
Above is my formula,
A2 is 3/7/2018
B2 is 3/9/2018
the name manager "myWeekend" has a value of 3/8/2018.
What I want to achieved with...