How to Use DateValue Function in Excel

Have you ever encountered a file with dates that just won’t give you an answer when you try to calculate days between them? One possible reason is that the date that appears to be a date is actually considered text in Excel. To know for sure, look at the justification. If the date is left-justified, … Read more