Hey all,

I have an idea I would like to use in Excel but not sure if it's possible. I have a list of dates in row 1, in row 2 I have number of employees scheduled for that day, for example:

4/1/2010 4/2/2010 4/3/2010 4/4/2010 and so on for a month...
0 2 0 5

On the summary page I would like to show the first date of the month where someone is scheduled, in this case 4/2/2010.

Is this something that can be accomplished?

Any tips would be greatly appreciated.