Solved

Date format issue

Posted on 2011-03-14
3
187 Views
Last Modified: 2012-05-11
Dear Experts,
very recently  you helped me with a nice formula to transfer data from an "import sheet" to a "report sheet"
When I paste from Outlook data into that sheet, I get a ready report on another sheet.
Now I have an issue with the date format.
When I copy and past the date data from Outlook to Excel I have it still correct. E.g. 14-Mar-11 but on the report page I get 40616. I tried to format the cell but without result!
Do I need to adapt the formula?
The formula below I use for all fields in the report sheet and it works fine with all kind of values but not with the date!

=IFERROR(INDEX('Data-Import'!2:2;MATCH(E$1;'Data-Import'!$1:$1;0))&"";"")

any solution?
see also:

http://www.experts-exchange.com/Microsoft/Applications/Q_26876677.html

thanks

0
Comment
Question by:Petersburg1
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 35127694
You are converting the return value to text. Use:
=IFERROR(INDEX('Data-Import'!2:2;MATCH(E$1;'Data-Import'!$1:$1;0));"")
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35128952
PS You will still need to format the cell as a date. :)
0
 

Author Closing Comment

by:Petersburg1
ID: 35129878
Thank you
Nils
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now