Results 1 to 15 of 15

Formula for calculating patient days with selected date range

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    10

    Formula for calculating patient days with selected date range

    I have been struggling with a formula. I have a spreadsheet where I need to calculate the number of days between two dates. However that calculation of days should only be calculated if the dates fall within a specific date range.

    For instance, I need to calculate the Length of Stay (LOS) for each patient whose date range falls within date range of example:
    Admit Date 03/01/2014
    Discharge Date 03/31/2014
    Where the date of discharge is not counted unless the patient was only admitted for one day.

    Patient Name Admit Date Discharge Date Length of Stay
    Patient A 02/28/2014 03/01/2014 0 (This day would be counted in February)
    Patient B 03/01/2014 03/03/2014 2
    Patient C 03/05/2014 03/12/2014 7
    Patient D 03/31/2014 04/01/2014 1
    Patient E 02/27/2014 03/02/2014 3
    Patient F 03/29/2014 04/03/2014 3

    Any assistance would be appreciated.

    Thank you,

    HospitalOfficer
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula calculating AVG # of orders per patient on given date
    By happy3sum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 06:10 AM
  2. Calculating time elapsed in days and count days within same range
    By michellem410 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-19-2008, 01:13 PM
  3. Replies: 3
    Last Post: 06-28-2006, 05:40 PM
  4. Replies: 6
    Last Post: 09-06-2005, 03:05 AM
  5. Replies: 6
    Last Post: 09-06-2005, 01:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1