Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    formula using earliest date (2003 SP3)

    Hi,

    Is it possible to create a formula where the formula selects the lesser value from several columns?
    I have to calculate how long it took from when a supervisor was advised of an incident to when the HSW dept was advised of the incident.

    We have recently switched to a new data storage and extract software company. One of the date columns that I used in calculations is no longer available.
    The closest I can get to my prior calculation is to search 4 other date columns for the earliest date.

    In the past my formula read
    ^=NETWORKDAYS(CC2,DS2,'G:MANAGER [Public holidays 2004 - 2010.xls]Sheet1'!$B$9:$L$15)-1

    Column CC is the same data (date supervisor was advised).
    Column DS now contains the date paperwork was received, which is not necessarily the earliest HSW were advised of the incident.
    Columns DQ, DS, DV & EA all contain dates. Whichever of these dates is earliest is the closest I can come to when HSW were advised of the incident.

    Is there a method to re-write the formula so that DS2 is replaced by the lowest value in DQ, DS, DV or EA ?

    Thanks for any assistance.

    capri

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula using earliest date (2003 SP3)

    You can replace the DS2 with Min(DQ2, DS2, DV2 , EA2)

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: formula using earliest date (2003 SP3)

    Thanks Mike,

    I appreciate your help. it works fine.

    capri

Posting Permissions

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