Calculating waiting times for a different conditions

[sophy_1402]

Hi there,

I have attached a datasheet I am currently working on which I hope will calculate the waiting times (in weeks) of various patients, depending on certain conditions. The patients who will be entered onto this datasheet will fall into 1 of 4 categories and I have inputted an example to highlight each one.

1. If the patient is an inpatient (IP in column B) with an appt date already made: Waiting time (F column) is calculated by the difference between the referral date and the appt date (see Robin Hood)

2. If the patient is an inpatient (IP in column B) still on the waiting list for an appt date: Waiting time (G column) is calculated by the difference between the referral date and the present date (see Jon Carrot)

3. If the patient is an outpatient (OP in column B) with an appt date: Waiting time (H column) is calculated by the difference between the opt-in date and the appt date (see Jane Kane)

4. And finally if the patient is an outpatient (OP in column B) still on the waiting list for an appt date: Waiting time (I column) is calulated by the difference between the opt-in date and the present date (see Des Line)

I need to keep the IP and OP waiting times separate and also be able to pull out the ongoing waiting times of patients still on the waiting list for monthly and yearly audits. This is the best way I can think of doing it. Any help would be much appreciated and if you have any suggestions or alternative ways I would love to hear them.

Thanks,

Sophy

[thepdaoson]

Please see attached file. It may meet your expectation.

F3=DATEDIF(C3,E3,"md")/7
G4=DATEDIF(C4,TODAY(),"md")/7
H5=DATEDIF(D5,E5,"md")/7
I6=DATEDIF(D6,TODAY(),"md")/7

You should format range F3:I23 in number with decimal.