Surgical Research Project

[rdale2]

Hi everyone,

I am working on a project regarding a robotic surgical procedure. I have a spreadsheet with a list of patients and the dates they had their consultations and the dates they actually had the procedure.

I need to generate an artificial "wait list" at various time points going back to the first of each month. Basically I need to count the number of times a given date, say Sep. 1 2012, falls between the consultation date and procedure date. I will be using this to generate a list of how many patients are waiting for their procedure on any given date.

I have tried messing around with the Countifs formula but haven't seemed to get it to work the way I want yet.

Any thoughts or help would be very much appreciated! Thanks in advance!

[Tony Valko]

Something like this...

A2:A30 = consultation dates
B2:B30 = procedure dates
E2 = 9/1/2012

=COUNTIFS(A2:A30,"<="&E2,B2:B30,">="&E2)

[rdale2]

Something like this...

A2:A30 = consultation dates
B2:B30 = procedure dates
E2 = 9/1/2012

=COUNTIFS(A2:A30,"<="&E2,B2:B30,">="&E2)

Thanks a bunch, it looks like this works! I guess my Countifs formula wasn't quite right before. Thanks again!

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.