#### jaadu

##### New member

- Joined
- Nov 13, 2011

- Messages
- 13

- Reaction score
- 0

- Points
- 0

- Excel Version(s)
- Excel 2010

hi - i have attached a spreadsheet in which I am trying to figure out the max and min value for the data set, by changing the date in cell A1.

so basically, if I enter Feb 17, 2011 in cell A1, it should help identify the max and min for the past 30 days (most likely until Jan 17, 2011), and if I change the date to Feb 18, 2011, then the max and min should go back to Jan 18, 2011.

can someone help me generate a formula for both the max and min?

feel free to post your suggestion here in the message board or in the attached excel spreadsheet.

thank you in advance for your time and any help you can provide will be greatly appreciated.

so basically, if I enter Feb 17, 2011 in cell A1, it should help identify the max and min for the past 30 days (most likely until Jan 17, 2011), and if I change the date to Feb 18, 2011, then the max and min should go back to Jan 18, 2011.

can someone help me generate a formula for both the max and min?

feel free to post your suggestion here in the message board or in the attached excel spreadsheet.

thank you in advance for your time and any help you can provide will be greatly appreciated.