http://thelazyadmin.com/blogs/thelazyadmin/archive/2007/04/20/convert-unix-time-values-into-excel-windows-time-formats.aspxDuring our migration we had a lot of issues with date formats. The old system didn't save its date as a type and as such caused us all sorts of trouble. The key to getting the dates working was to apply a cryptic yet simple formula to the date valuesenCommunityServer 2.1 SP2 (Build: 61129.2)