Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a file with customer information
NI number
Forename
Surname
Date purchased car
Date purchased house
Date purchased van
I'd like to be able to pull out the earliest date between date purchased car, date purchased house and date purchased van. For example see below
NI num | Forename | Surname | Date purchased car | date purchased house | Date purchased van | Earliest |
---|---|---|---|---|---|---|
111111 | Bob | Smith | 01/01/2014 | 05/05/2014 | 01/08/2014 | 01/01/2014 |
Can this be done?
=Date(RangeMin([Date purchased car],[date purchased house],[Date purchased van]))
use the function Min(date)
=Date(RangeMin([Date purchased car],[date purchased house],[Date purchased van]))