Question

20. In cell C9, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G8).

Answer 1

To find the earliest date in the project schedule range C6:G8, you can use the MIN function.

In cell C9, enter the following formula:

=MIN(C6:G8)

This formula will compare all the dates in the range C6:G8 and return the earliest (minimum) date.