Date diff in excel 2007

		Microsoft Office Forums > Microsoft Excel > Excel
Date diff in excel 2007

04-13-2017, 06:54 AM

otuatail

Windows 7 64bit Date diff in excel 2007

Office 2007

Competent Performer

Join Date: Jun 2012

Posts: 245

=DATEDIF(F1,E1,"D")
=DATEDIF(E1,F1,"D")

All you have done is reversed the 2 cells. This would give a negative value but it doesn't work.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date	angie450	Excel Programming	2	08-19-2014 08:50 AM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM
Date problem in excel 2007	msheyworth	Excel	2	06-12-2012 05:10 AM
range.insertfile produces diff result between word 2010 and 2007	rsmedley	Word	1	02-15-2012 10:48 PM
Colorised diff add-on?	liamf	Outlook	0	12-15-2010 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:02 PM.