Set Cell Range in Formula by referencing Cells

Timmy Seals

New Member
Joined
Sep 25, 2014
Messages
1
Help! I'd like to reference cells to define a cell range for a formula.
I'm trying to use a formula to find the minimum value in a range, where the range can be changed outside of the formula by referencing a cell.

For instance if I enter two dates, one in B2 (19/12/2013) and one in B3 (31/12/2013), the formula will only find the minimum value within these dates. Any ideas?

Many thanks, Tim
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,108,956
Messages
5,525,884
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top