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)