SUMIF and COUNTIF Between Dates with Cell References Dates Help

I am trying to create a workbook that will ultimately include a series of worksheets to calculate volumes for each month. I know I calculate volumes between a range of dates by inputting greater/equal than and less/equal than the actual month start and end dates (see below) to get the data I am seeking.

=SUMIFS(ALLTRAN[Total Cash Paid],ALLTRAN[Date Worked],">=5/1/2018",ALLTRAN[Date Worked],"<=5/31/2018")

However if I build in a Vlookup formula in another cell to tell me the start and end dates based on the month of the worksheet, no matter how I input this it does not seem to work. So for example my Vlookup to find the Start Date is in P33 and the End Date is in Q33. Regardless if I put quotes or not I can’t get the above formula to work using cell references versus the physical dates. I’m just trying to create something with as minimal maintenance as possible where I won’t have to physical update the date in the formula M2M or Y2Y. Any advice? Or can this not be done?

=SUMIFS(ALLTRAN[Total Cash Paid],ALLTRAN[Date Worked],">=P33",ALLTRAN[Date Worked],"<=Q33")

The correct syntax for that second formula would be like this:

">="&P33 and "<="&Q33

Thank you Falcon! You're a god send, I wish I had asked this question ages ago!