calculating number of days between two dates

  • Thread starter Thread starter sandy
  • Start date Start date
S

sandy

On an Excel spreadsheet, how do I calculate the nubmer of
days between two dates? I previously used the DAYS360
function, but now I need to calculate based on a 365-day
year.
 
Try using the DATEDIF function. An example would be:

=DATEDIF("9/16/2003","9/21/2003","D")

Should return "5". The formula is:
=DATEDIF(StartDate, EndDate, Unit)
Where "Unit" is "D" for days, "M" for months, etc.

Hope that helps.

Regards,
James S
 
On an Excel spreadsheet, how do I calculate the nubmer of
days between two dates? I previously used the DAYS360
function, but now I need to calculate based on a 365-day
year.
Click to expand...


Simply subtract one from the other. If the later date is in A2, and the
earlier date in A1, then =A2-A1.


--ron
 
If you've entered the data in a format that Excel recognizes as a date (rather than text), just
subtract, i.e. =B1-A1.

BTW, DAYS360 is primarily for bond trades and other financial calculations.
 
Back
Top