Time and Date info to excel

I am trying to run data on when I receive the most emails over the last year. Ultimately I would like to export my emails to an excel spreadsheet that has a column with date and time (in or two columns).

I have the emails in Outlook, an Yahoo inbox and a Gmail inbox (after the forwarding rules). Is there an easy way to do this?

I have tried in outlook to simply copy and past into excel. It either only has the time (if it is the same day) or it only has the date (if it is older than the same day). Doesn't have both. When I export a file in outlook, it doesn't carry the info of when it was received.

Any ideas? Thanks!