![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
it now shows the correct date, but does not allow me to format to a date. also, altered some formulas on the sheet. any ideas?
|
![]() |
Tags |
analysis, date, date field calculation |
|
![]() |
||||
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 |
![]() |
MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
![]() |
tsindos | Word | 4 | 10-04-2011 11:20 PM |
![]() |
vandy | Word | 1 | 09-23-2009 11:32 AM |