Excel: help with creating a formula

Hi all I hoping you can kindly assist me on this great forum! I am trying to create a formula which gives me a total figure of an amount of tickets that are 'pending' in a specific date range, i have tried various formulas with no success, the date field contains a timestamp which needs to be excluded in the results to summarise i need to know how many tickets are in 'pending' status on '21/07/2015' Could you assist me with the formula please

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of July 21, 2015.

For more resources for Microsoft Excel