• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Date format issue

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
Petersburg1
Asked:
Petersburg1
  • 2
1 Solution
 
Rory ArchibaldCommented:
You are converting the return value to text. Use:
=IFERROR(INDEX('Data-Import'!2:2;MATCH(E$1;'Data-Import'!$1:$1;0));"")
0
 
Rory ArchibaldCommented:
PS You will still need to format the cell as a date. :)
0
 
Petersburg1Author Commented:
Thank you
Nils
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now