Issue
The dates in the Excel Sheet are 1/0/1900 when creating a customize report for example the report of the Number of Daily Unique Visitors.
Solution
The solution is quite simple because you only need to verify a few things and maybe start a few services.
– Verify that the following service applications have been started/installed
- Excel Services Application
- State Service
- Usage and health data collection
- Web Analytics Service Application
– Verify that the trusted file location in Excel Services Application has ‘Allow user-Defined functions’ enabled.
– Verify that the following services in SharePoint have been started
- Claims to Windows Token Service
- Excel Calculation Services
- Web Analytics Web Service
- Web Analytics Data Processing Service
You should be able to see the correct data after checking the above settings