Date diff in excel 2007

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

FAQ

Mark Forums Read

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 »

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
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 09:43 AM.