Question description:
This user has given permission to use the problem statement for this
blog.
I am looking at some patient data. I need to calculate the total number of days and months each patient has been receiving our services. I have a enrollment date column, whether the patient is active or not. If the person is active, I specified today's date as the end date in order to calculate the number of days and months. How do I calculate the number of days and months (separate columns dedicated to each) for those who are not active (don't have a end date).
Solved by T. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/08/2017 - 10:05
Welcome, Thanks for choosing Got It Pro-Excel
Excelchat Expert
29/08/2017 - 10:06
How may I help you today?
Excelchat Expert
29/08/2017 - 10:07
hi
Excelchat Expert
29/08/2017 - 10:10
hi
Excelchat Expert
29/08/2017 - 10:16
hi
User
29/08/2017 - 10:17
no
User
29/08/2017 - 10:19
yes, but what if I have missing data for the end or start date?
Excelchat Expert
29/08/2017 - 10:19
can you add the data
User
29/08/2017 - 10:19
so how would I treat the missing data?
User
29/08/2017 - 10:20
because I eventually need to create a pivot table from the data and I can't have blank cells
User
29/08/2017 - 10:20
are you still there?
Excelchat Expert
29/08/2017 - 10:20
date of enrollment is start date
Excelchat Expert
29/08/2017 - 10:21
and if the column b = n what that mean
Excelchat Expert
29/08/2017 - 10:22
can you explain more
Excelchat Expert
29/08/2017 - 10:22
hi
Excelchat Expert
29/08/2017 - 10:23
the time is up you must extended it
Excelchat Expert
29/08/2017 - 10:25
hi
Excelchat Expert
29/08/2017 - 10:25
where you go
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.