Calculating dates some are partial

P

philky001

Board Regular
Joined
Jun 8, 2005
Messages
129
HI I have a small data set as this: I need to calculate the number of days the client was in the program.
But ion
program_startprogram_end
05/28/2019
08/29/201801/14/2019
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
How about:

Book1
ABC
1program_startprogram_end
228/05/2019 
329/08/201814/01/2019138
Hoja4
Cell Formulas
RangeFormula
C2:C3C2=IF(AND(A2<>"",B2<>"",B2>=A2),DATEDIF(A2,B2,"d"),"")
 
Upvote 0
HI Thanks again DA. you're gonna hate but now I need to get the median. Is it just that I have to do the median formula over the days of your formula?
 
Upvote 0
No problem, just explain with examples the result you need.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Excel Formula to highlight most recent record
Replies
3
Views
100
etaf
etaf
V
  • Solved
Formula to calculate automatically progressive average
Replies
5
Views
200
etaf
etaf
nburaq
  • Solved
Calculate interval between dates based on input at another columns
Replies
2
Views
137
awoohaw
awoohaw
M
  • Question
HELP IDENTIFY ORIGINAL START DATE BASED ON CONTINOUS SERVICE RULES
Replies
0
Views
353
mrshuck
M
J
  • Solved
Add 1 day to a date within a range as long as 2 conditions are met [without macros]
Replies
4
Views
566
juanam
J

Forum statistics

Threads
1,215,039
Messages
6,122,802
Members
449,095
Latest member
m_smith_solihull

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top