Excel date difference calculations

Can you please help me calculate the difference (in calendar days) between the two dates in columns A and B on both tabs (see attachment)Dates_comp.xlsx. When I use the =DATEDIF(A7,B7,"d"), Excel returns a #VALUE! error, probably because it does not recognize the dates.

Thank you for your tremendous assistance!
saved4useAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
See if this works for you:
=DATEVALUE(TEXT(A19,"mm/dd/yyyy"))-DATEVALUE(LEFT(B19,9))
0
 
Vijaya KumarCommented:
=DATEDIF(TEXT(A8,"dd-mmm-yy"),TEXT(LEFT(B8,FIND(":",B8)-1),"dd-mmm-yy"),"d")

Note that u need b8 at first and then a8 otherwise #num will thrown
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.