calculating number of days between two dates

[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.

 

[James S]

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

 

[Ron Rosenfeld]

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

 

[Myrna Larson]

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.