Change the date format in Data Warehouse and ReportBuilder so Excel can easily manage.

[#1]

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.

Thanks!

Raphael

[#2]

Same with ReportBuilder!!

[#3]

Flagging as a duplicate of Change Date Format to something that can be recognised by Excel - show your support by upvoting there!