Current Function:
The Goal:
To SUM the contents of a table that have a specific name and are within the date range of the current month.
In the image below, dates in the top left are auto populated by "=Today()","=EOMONTH(B36,-1)" and "=EOMONTH(B36,0)" respectively.
All dates in this sheet are formatted as "Short Dates".
The innermost FILTER function successfully pulls the total of all table entries labelled "Weaver", but I'm having trouble filtering that result by the current date range.
"A value used in the formula is of the wrong data type."
Excel Formula:
=SUM(FILTER(FILTER(Table5[Amount],Table5[Description]=F33,0),(Table5[Date]>B37)*(Table5[Date]<=B38),0))
The Goal:
To SUM the contents of a table that have a specific name and are within the date range of the current month.
In the image below, dates in the top left are auto populated by "=Today()","=EOMONTH(B36,-1)" and "=EOMONTH(B36,0)" respectively.
All dates in this sheet are formatted as "Short Dates".
The innermost FILTER function successfully pulls the total of all table entries labelled "Weaver", but I'm having trouble filtering that result by the current date range.
"A value used in the formula is of the wrong data type."