Problem with formula sum ifs

[steel1968]

Hi can anyone help me correct this formula
Within sheet Completed Column D are dates
Within sheet Completed Column E are Names
Within sheet Wage Column B2 and C2 are dates
If i type the dates into the formula the formula works but i need it to pick up the cell reference
=SUMIFS(Completed!B:B,Completed!D:D,">="&DATEVALUE("20/04/20"),Completed!D:D,"<="&DATEVALUE("26/04/20"),Completed!E:E,"Martin")
Above Works
=SUMIFS(Completed!B:B,Completed!D:D,">="&DATEVALUE(B3),Completed!D:D,"<="&DATEVALUE(C3),Completed!E:E,"Martin")
I need this one to works
What am i missing any help gratefully received

 

[arthurbr]

Try simply removing the DATEVALUE function

=SUMIFS(Completed!B:B,Completed!D:D,">="&B3,Completed!D:D,"<="&C3,Completed!E:E,"Martin")

BTW using entire ranges is bad practice. Use Excel Tables to accommodate varying length ranges

 

[steel1968]

=SUMIFS(Completed!B:B,Completed!D:D,">="&B3,Completed!D:D,"<="&C3,Completed!E:E,"Martin")

Thats the solution thank you very much