Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-25-2014, 11:11 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

So "trade blotter" RTN-FIX.xlsx the date you are copying from there is in Column A.

Interesting. I see something completely different. When I paste the first date from PerformanceSummary, 12/5/12, into a blank sheet here, it becomes 12/4/08. So 4 years AND A DAY EARLIER.

o-O
Reply With Quote
 

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 05:34 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