Converting duration to integer

Geoff Walsh wrote:
Hi

I have a duration value as a result of subtracting one date from another...i.e. 5d

I need to convert it to an integer (i.e 5) so that i can use it in other formulas without the "d" sticking with the result...

Any ideas...

The best one: read 'iWork Formulas and Functions User Guide" available from the Help menu.

Doing that you would be aware of a function designed to do what you need !

Assuming that the start of the period is stored in B2, the end is stored in C2
in D2 enter the formula:
=DATEDIF(B,C,"D")

Yvan KOENIG (from FRANCE mercredi 5 août 2009 12:02:09)