Hi,
My data set contains 'Order Date' (Day/Month/Year format) in col 'A' and 'Shipped to Store Date' (which is a date/time stamp combination) col 'B'. I would like to calculate the 'Days Since Order' col 'C' but cannot seems to figure out how to break and re-format the Ship to Date value.

Also, unsure if this is best done through vba or formula.

Any guidance would be appreciated.

Order Date ShippedToStore Date Days Since Order
6/27/2013 Sat 29 Jun 2013 14:45:18
6/27/2013 Sat 29 Jun 2013 14:45:18
7/9/2013 Wed 10 Jul 2013 15:00:38
7/14/2013 Tue 16 Jul 2013 15:00:50
7/14/2013 Tue 16 Jul 2013 15:00:50