Forum Discussion
Error with difference between dates - DATEDIF
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
| C | D | E |
| 5/18/20 | 7/2/20 | 2/14/00 |
formula used =D2-C2
How do I fix this?
Thank for help,
Lindsay
2 Replies
Select the cell with the formula and select General as number format.
HansVogelaar Thank you! I knew it must be an easy fix like that 🙂 - Lindsay
