| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Current Patient Count
Oh Excel Gurus, please hear my plea!
I've got sheet1 named Patients with A = Name B = StartDate C = EndDate I'm looking for a formula that I can enter on sheet2 (Current Client Count) that looks at the Patients sheet and brings over the names for entries with start dates but no end dates and ignores names with both start and end dates. The point being that people start and are current. When they're done they have an end date and are no longer current and should not be on the Current Clinet Count sheet. Can someone please help me with a formula that does this? Thanks a million in advance! Dax |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for current stock count needed | Excel Worksheet Functions | |||
| How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
| Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) | |||
Threaded Mode
