I want to include a new condition (within a date range and calculate) in the existing formula, but couldn't figure out how. Can you please help me add that condition?
I have formula in F2:F8 and this is the formula in F2
I want to add a condition, calculate if it's within the date range specified in E1 and F1 which is last one year.=SUMPRODUCT((WEEKDAY($A$2:$A$1000,2)=E2)*($A$2:$A$1000<>"")*($B$2:$B$1000=""))
I have enclosed a sample file, please find the attachment.
SAMPLE.xlsx
Bookmarks