Note: As of July 9, 2018, Blackbaud's School Management solutions (which include Core, onBoard, onCampus, onMessage, and onRecord) are utilizing a new top level navigation. This primarily affects users performing administrative tasks-constituent navigation for most parents, students, faculty, and alumni will remain the same. We appreciate your patience as we work to update our documentation. If you are seeing this message, the content of this solution is still being vetted for possible updates. Please refer to this mapping document if you need assistance finding a task in the new navigation.
When exporting a document to Excel, users may notice that dates in the document are showing as 4 years and 1 day ahead of what is recorded in the application.
Excel for Windows uses a date formula starting from January 1st, 1900; however Excel for Mac 2008, and any earlier versions, uses a date formula starting from January 1st, 1904. Excel for Mac 2011, and beyond, have switched to the January 1st, 1900 date formula to match the Windows version.
Steps to edit the setting:
1. Open the affected Excel document. 2. Select File > Options. 3. Click Advanced. 4. Scroll to the setting titled When Calculating This Workbook. 5. Unmark the option titled Use 1904 Date System.
*** Note: Adjusting this setting affects all dates in the current workbook. This setting while not affect other workbooks, only the one currently being worked, so it will need to be adjusted for each export.