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
