Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Average Length of Service | Excel Worksheet Functions | |||
Length of time from date/time custom format | Excel Discussion (Misc queries) | |||
Calculating an average with conditions. | Excel Discussion (Misc queries) | |||
Calculating the sum with multiple conditions | Excel Worksheet Functions | |||
calculating SUM with two conditions | Excel Worksheet Functions |