sumifs criteria date and year

[sontisuresh]

I have an excel sheet with datasheet tab and profit_loss tab.
In the datasheet i enter dates and rent collected
I am using SUMIFS function to extract data from datasheet tab to profit_loss tab using the dates in the datasheet tab.
If I change the year in profit_loss tab the amounts in the profit_loss should reflect 2019 data.
SUMIFS function should include the year criteria


=SUMIFS(revenue,revenuedate,">="&0+("1/"&D$4),revenuedate,"<="&EOMONTH(0+("1/"&D$4),0),propertyname,$B6)


revenue is a table
revenuedate is a named range column
propertyname is a named range column


Thanks for all your help. How can I attach a sample file