Date range mysteriously adding 4 years

		Microsoft Office Forums > Microsoft Excel > Excel
Date range mysteriously adding 4 years

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-25-2014, 10:47 AM

akatz85

Mac OS X

Office 2008 for Mac

Novice

Join Date: Mar 2014

Posts: 10

pasting from trade blotter

gebobs,

I am pasting from trade blotter, which I have attached. I am not sure where the corruption begins, but it adds 4 yrs. For instance 12/5/12 will be 12/5/16

Thanks a lot for your help

Attached Files

	Performance SummaryFIX.xlsx (86.9 KB, 13 views)
	RTN-FIX.xlsx (92.7 KB, 12 views)

Tags

analysis, date, date field calculation

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.