Read latest news today, breaking news headlines, Top news. Discover national and international news on economy, politics, defence, sports, science, environment and more on The Economic Times.

Subtraction is the easiest way to count days between two dates in Excel. You can use the arithmetic operator – (minus sign) to subtract one date from another to find the number of days between them.

Click the drop-down arrow in this area and choose either of the two "Date" options. The long number in the cell with transform a date, which will be the midpoint between your two given dates.

This simple Google Sheets formula will show you the number of days between two dates.