+ Reply to Thread
Results 1 to 5 of 5

Time between 2 dates with 2 conditions

  1. #1
    Registered User
    Join Date
    05-21-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Time between 2 dates with 2 conditions

    I need help with formula to calculate time (in weeks) from date of intake to date of allocation for those aged 4y 0m or older but younger than 18y 0m (at intake) who are triaged as urgent (as in attachment with irrelevant cells hidden).

    Formula used to get age at intake was of form : =DATEDIF(D3,B3,"Y") & "y " & DATEDIF(D3,B3,"YM") & "m"

    Any help appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Time between 2 dates with 2 conditions

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    05-21-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Time between 2 dates with 2 conditions

    Thanks. That's perfect. However, I thought I'd be able to work out 2 more functions from here but had no luck so would appreciate further help on them please:
    1. Exactly the same formula again but the data are in a different worksheet called "Data"
    2. A formula that will give the no. of those aged 4y 0m or older but younger than 18y 0m (at intake) who are triaged as urgent and allocated within 1 week of date of intake
    Thank you

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Time between 2 dates with 2 conditions

    How about attaching a sample spreadsheet? (Word docs with pictures don't really help with formula construction.)

  5. #5
    Registered User
    Join Date
    05-21-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Time between 2 dates with 2 conditions

    Thanks for the advice.

    Relevant file attached. I've left everything in the summary pages as otherwise there'd be chaos there.

    Data is in the "Bankstown" worksheet.

    The 2 formulae I'm lost on are in highlighted cells:

    (1) cell G11 of worksheet "Summaries": Time (in weeks) from date of intake to date of allocation for those aged 4y 0m or older but younger than 18y 0m (at intake) who are triaged as urgent.

    (2) cell C8 of worksheet "Clinical indicators 4-6": No. of those aged 4y 0m or older but younger than 18y 0m (at intake) who are triaged as urgent and allocated within 1 week of date of intake.

    With these I should be able to work out the rest.

    Thank you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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