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!
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
See if this works for you:
Vijaya KumarCommented:

Note that u need b8 at first and then a8 otherwise #num will thrown
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.