Richard has attended:
Excel Intermediate course
Date Formats
Hi,
I am attempting to calculate the number of days between 2 dates. I am happy with how to do that except that the dates are sent to me on a spread sheet in the following format '20100627' - which excel doesn't seem to recognise as a date. Is there a way to calculate the days between 2 dates in that format?
Kind regards,
Rich
RE: 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
