Calculation to determine days between two dates

[Dubleaa]

I am trying to determine if it is possible to write a calculation in Excel
that will tell me how many days have elapsed from 5/17/1995 to 3/15/2005.

 

[Don Guillett]

http://www.rondebruin.nl/

Go to the url and get Ron's search addin
then search for datedif and datediff

 

[Alan]

I am trying to determine if it is possible to write a calculation in
Excel that will tell me how many days have elapsed from 5/17/1995 to
3/15/2005.

=VALUE("15/3/05")-VALUE("17/5/95")

= 3590 days

OR

=TODAY()-Value("17/5/95")

= 3592 days at the time of posting.

The second if you always want it to 'today'.

HTH,

Alan.

 

[Fred Smith]

You just subtract them. Eg,

=b1-a1

Format the result as a number.