Hi -

I have a database which is built to track values in a calendar. The dates are all in a row at the top, and the values are in lower rows, and are tied to title information in columns to the left. The values in the rows start and stop and I need equations/functions/etc. to identify the dates on which the data starts and stops for each row. All of the values are greater than or equal to zero. The data in each row should not start/stop more than once.

I have figured out how to do this using DMIN/DMAX, but only when the data is sorted in columns rather than in rows. I can't transpose this data. Does anybody know of a function/formula that will allow me to determine the start/stop dates?

Thanks.