Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2014, 11:33 AM
gebobs gebobs is offline Date range mysteriously adding 4 years Windows 7 64bit Date range mysteriously adding 4 years Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #2  
Old 03-25-2014, 12:15 PM
akatz85 akatz85 is offline Date range mysteriously adding 4 years Mac OS X Date range mysteriously adding 4 years Office 2008 for Mac
Novice
Date range mysteriously adding 4 years
 
Join Date: Mar 2014
Posts: 10
akatz85 is on a distinguished road
Default not working

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?
Reply With Quote
Reply

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 mysteriously adding 4 years Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM
Date range mysteriously adding 4 years Adding months to a Date tsindos Word 4 10-04-2011 11:20 PM
Date range mysteriously adding 4 years Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft