Steve G,
This formula woked for the columns and cells that I already had "True".
I have 7 columns; <30, 31-60, 61-90 and so on!
I need each column to show how many days a capa is open?
I hope this explains what I want.

Bebz


"bebz" wrote:

I would like to be able to show number of days in seperate columns. Using
dates as values.
e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60.
and so on!
Microsoft Office Excel 2003