Aug 12 2020 01:44 PM
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
Aug 12 2020 02:18 PM
Select the cell with the formula and select General as number format.
Aug 12 2020 02:57 PM
@Hans Vogelaar Thank you! I knew it must be an easy fix like that :) - Lindsay