Date diff in excel 2007

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

FAQ

Thread Tools

Display Modes

04-13-2017, 12:10 AM

otuatail

Windows 7 64bit Date diff in excel 2007

Office 2007

Competent Performer

Join Date: Jun 2012

Posts: 245

Date diff in excel 2007

Hi I have 3 cells E1,F1,G11

I want to store cell IDs containing dates in E1 and F1. Cell G1 will show the number of days difference.

EG:

E1 = '06/04/2017 19:00:00'
F1 = '28/04/2017 19:00:00'
G1 = '22 Days'

I tried entering =DATEDIF(F1,E1,"D") into cell G1 but it doesn't work.

« Previous Thread | Next Thread »

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 01:42 PM.