Date Formats

Hello Rich,


Thank you for your question regarding date format.

Unfortunately there is no way excel can calculate the date in its present format. You need to convert these dates. One way is to select your dates, change the format to number no decimal places.
With these dates selected, from the Data Ribbon, Choose the Text to Columns button. Skip thru the wizard until step 3, then select the Date option, YMD, finish. The numbers will change, you can now format these to a date format.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer