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.

Reach out

Find us at the office

Ravi- Hoult street no. 33, 84286 Santo Domingo, Dominican Republic

Give us a ring

Shammah Ceragioli
+38 858 597 690
Mon - Fri, 9:00-15:00

Join us