Question: How to subtract a date from a date in Excel?

Contents

Just subtract one date from the other. For example if cell A2 has an invoice date in it of 1/1/2015 and cell B2 has a date paid of 1/30/2015, then you could enter use the formula =B2-A2 to get the number of days between the two dates, or 29.

Write us

Find us at the office

Kyker- Kublin street no. 42, 51864 Pretoria, South Africa

Give us a ring

Carnell Mckean
+65 937 708 93
Mon - Fri, 10:00-20:00

Contact us