Date range mysteriously adding 4 years

gebobs · #1 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.

akatz85 · #2 03-25-2014, 12:15 PM

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?

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