Thread: [Solved] Date diff in excel 2007
View Single Post
 
Old 04-13-2017, 06:54 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
=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.
Reply With Quote