Date range mysteriously adding 4 years

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

03-25-2014, 12:15 PM

akatz85

Mac OS X

Office 2008 for Mac

Novice

Join Date: Mar 2014

Posts: 10

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?

Tags

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 02:21 AM.