Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date Formats
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Date Formats
Resolved · Urgent Priority · Version 2007
Reply Mon 27 Jun 2011, 15:19Delegate Richard said...
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
For upcoming training course dates see: Pricing & availability
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
|