one question, is the date in Excel a date or a text? Normally QV import a datefield even as a datefield and that means it is a number. In format numbers you can than change back to a dateformat.
Otherwise QV can interpret even textfields into a datefield using the function date#(...).
Ofcourse you can add dates, sometimes you have to use the function num(...) to change back from a dateformat to a numberformat.
In the excel, the field is a date with the format 'MMM-YY'. For example, in the excel file, the date is 'JAN-10' but when I tried to load to qlikview, it appears 40179. So, I think that this strange number is the number of days between 'JAN-10' and the '01/01/1900' date. So, my question is what shoud I do to interpret or convert these strange numbers into normal dates.
I have loaded dates from another excel files without problems but for this particular excel file, it generates these strange numbers.