# Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.