calculating number of days between two dates

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

-----Original Message-----
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.

On Tue, 16 Sep 2003 14:25:48 -0700, "sandy" wrote:

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.


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.

On Tue, 16 Sep 2003 14:25:48 -0700, "sandy" wrote:

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.