Function help

[valerie]

Hi,
I would like to know is there a particular function for calculating the
number of days between 2 dates?
Any help would be appreciated.

 

[Gord Dibben]

Valerie

Check out Chip Pearson's info on and usage of the un-documented(except xl2000)
DATEDIF Function.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben XL2002

 

[RagDyer]

Try this link:

http://www.cpearson.com/excel/datedif.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,
I would like to know is there a particular function for calculating the
number of days between 2 dates?
Any help would be appreciated.

 

[Peo Sjoblom]

If you only want days, just subtract start date from end date.

=A2-A1

format as general

If you are looking for years and months as well you better use datedif
although it fails on some occasions

 

[valerie]

Thanks for the link. It helped.