Error with difference between dates - DATEDIF

Copper Contributor

Hello,

I keep getting an error when trying to find the days between two dates. I have used the =D2-C2 function as well as =DATEDIF(C2,D2,"D") and get and irrelevant date instead of number of days. E.g. I get 

CDE
5/18/207/2/202/14/00

formula used =D2-C2

 

How do I fix this? 

 

Thank for help, 

Lindsay 

2 Replies

@LMPayeur 

Select the cell with the formula and select General as number format.

@Hans Vogelaar  Thank you! I knew it must be an easy fix like that :)  - Lindsay