4. Excel offers many other date format choices. In the cell format menu, click on "More Number Formats…" at the bottom. 5. In the window that pops up, make sure "Date" is chosen under the ...

Google Sheets has the power to calculate the number of days between two dates, regardless of the date format entered. The only requirement is consistency between manually typed dates and the ...