Calculating length of time with conditions
 

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.

Calculating length of time with conditions
 

You want Datedif, as in:
=Datedif(entry date, if(exit date = "",today(),exit date),"m")

Regards,
Fred

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