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.

Join us

Find us at the office

Drum- Kolsky street no. 57, 62517 Manama, Bahrain

Give us a ring

Henrick Wertman
+47 414 731 31
Mon - Fri, 11:00-17:00

Tell us about you