Prev: Concatenate By Selection
Next: Simple Question Complicated Formula
From: markg on 16 Dec 2009 14:55
I would like to calculate the length of time a client spends in a program.
We use three columns (entry date, exit date, today's date). If a client is
still enrolled I would like to base the length of time on today's date. If
the client leaves the program, I would like to base the length of time on the
exit date. Preference is to display the length of time in months. Thank you.
From: Fred Smith on 16 Dec 2009 15:52
You want Datedif, as in:
=Datedif(entry date, if(exit date = "",today(),exit date),"m")

Regards,
Fred

"markg" <markg(a)discussions.microsoft.com> wrote in message
news:19344913-5535-4201-9662-7049421CD505(a)microsoft.com...
>I would like to calculate the length of time a client spends in a program.
> We use three columns (entry date, exit date, today's date). If a client
> is
> still enrolled I would like to base the length of time on today's date.
> If
> the client leaves the program, I would like to base the length of time on
> the
> exit date. Preference is to display the length of time in months. Thank
> you.

 | 
Pages: 1
Prev: Concatenate By Selection
Next: Simple Question Complicated Formula