|
|
#5
03-25-2014, 11:33 AM
|
|||
|
|||
I understand what's wrong. The Performance Summary sheet has the option checked for 1904 date system.
Go to File:Options:Advanced. About 4 sections from the end is "When calculating this workbook" Uncheck "1904 date system". You should be fine now. You just have to update all your dates. 
|
| Tags |
| analysis, date, date field calculation |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help me with simple IF stmt to test date within a range | tomseeley | Excel | 4 | 02-23-2014 02:13 PM |
| Adding an amount to a min-max range | Nibbles | Excel | 4 | 06-13-2013 08:05 AM |
 Date Range Prompt
|
MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
|
Adding months to a Date
|
tsindos | Word | 4 | 10-04-2011 11:20 PM |
|
Using Field Codes to Calculate 5 years from a Date
|
vandy | Word | 1 | 09-23-2009 11:32 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode