Calculation to determine days between two dates
 

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.

http://www.rondebruin.nl/

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

--
Don Guillett
SalesAid Software

"Dubleaa" wrote in message
...
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.

"Dubleaa" wrote in message
...

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.

You just subtract them. Eg,

=b1-a1

Format the result as a number.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Dubleaa" wrote in message
...
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.