Thread: [Solved] Date diff in excel 2007
View Single Post
 
Old 04-13-2017, 12:10 AM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Jun 2012
Posts: 245
otuatail is on a distinguished road
Default 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.
Reply With Quote