Hello,
I’m learning about Database functions – specifically DSUM - and I’m stuck at how to enter in the ‘criteria section’ dates between e.g. Sum of sales from 18th October 2014 to 17th October 2015.

I’ve set up the criteria section at the top of the worksheet, above the data table, with several blank lines to enter the criteria into.

One of the fields in the data table is ‘Order Date’ with a list of dates.

I’m not sure how to enter the criteria I’m looking for, as its between two dates, and I’m not sure how to format this correctly.

Any help would be greatly appreciated. Thanks in advance.


Cheers