Formula to calculate date difference

  • Thread starter Thread starter Brigitte D'Andrea
  • Start date Start date
B

Brigitte D'Andrea

I have one column with a "beginning date", another column
with "ending date" and need the formulat to calculate the
number of day difference between the two?
Could anyone please provide quickly for me? Of course, I
need this ASAP.
 
Brigitte,

Dates are just numbers, so you can subtract the beginning date from the
ending date to return the number of days between the dates. E.g.,

=end_date - start_date

Be sure to format the result cell as General or numeric.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Since XL stores dates as integer offsets from a base date, you can
just subtract the two:

A1: 1 November 2003
A2: 3 November 2003

A3: =A2 - A1 ==> 2
 
Brigitte,

Dates are just numbers, subtract one from the other.

If you just want working/business days, try NETWORKDAYS
NETWORKDAYS(start_date,end_date,holidays)

where holidays is a range of holiday dates. It's part of the Analysis
Toolpak addin, so you will need to install this.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top