I was using date format in excel and as stated Lansweeper wants it in a specific format. I used text format and defined the values as stated and everything imported correctly.
Thanks.
walkerpbw if it is agentusername you must us AD username without the domain, mine was just user initials.