Length of stay - health care

[bakerwe3]

So I am looking work out what the number of patients that will be discharge every day assuming an a average length of stay in hospital. As an example

let say that average length of stay is 7 days

01/01 - 10 patients are admitted
02/01 - 20 patients are admitted
03/01 - 5 patients are admitted

I want after day 7, 10 patient would be discharge but want a formula, Rather than me manually working it out. Any ideas?

 

[StephenCrump]

Do you mean like this?

Book6
	A	B	C	D	E	F
1			Expected
2	Date	Admissions	Discharges
3	1 Jan 2020	10			Expected stay
4	2 Jan 2020	20			7	days
5	3 Jan 2020	5
6	4 Jan 2020	...
7	5 Jan 2020
8	6 Jan 2020
9	7 Jan 2020
10	8 Jan 2020		10
11	9 Jan 2020		20
12	10 Jan 2020		5
13	11 Jan 2020		...
Sheet1

Cell Formulas
Range	Formula
C3:C13	C3	=IFERROR(VLOOKUP(A3-N,Admissions,2,),"")

Named Ranges
Name	Refers To	Cells
Admissions	=Sheet1!$A$3:$B$13	C3:C13
N	=Sheet1!$E$4	C3:C13

 

[bakerwe3]

Thank you