don't use July 1, 2013 but 1/7/2013
then it's just about using the DATAVALUE() function to transform text into dates. The function can only deal with dd/mm/yyyy dates.
Same with ReportBuilder!!
Flagging as a duplicate of Change Date Format to something that can be recognised by Excel - show your support by upvoting there!