software

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 amp; 31, column 2= # 0f days between 1 amp; 60.
and so on!
Microsoft Office Excel 2003


You can use the DATEDIF function.

=DATEDIF(A1,AE1,quot;dquot;)

This is where the two dates that you are using are located in cells A1
amp; AE1. The quot;dquot; tells the formula to calculate days. This includes
weekends an holidays.

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=496204=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200gt;0),--($B$2:$B$200-$A$2:$A$200lt;=30))

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200gt;30),--($B$2:$B$200-$A$2:$A$200lt;=60))

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;bebzquot; gt; wrote in message
...
gt; I would like to be able to show number of days in seperate columns. Using
gt; dates as values.
gt; e.g. column 1= # of days between 1 amp; 31, column 2= # 0f days between 1 amp;
60.
gt; and so on!
gt; Microsoft Office Excel 2003
Sorry, to count days use

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200gt;0),--($B$2:$B$200-$A$2:$A$200lt;=30),$B
$2:$B$200-$A$2:$A$200)

and

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200gt;30),--($B$2:$B$200-$A$2:$A$200lt;=60),$
B$2:$B$200-$A$2:$A$200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;bebzquot; gt; wrote in message
...
gt; I would like to be able to show number of days in seperate columns. Using
gt; dates as values.
gt; e.g. column 1= # of days between 1 amp; 31, column 2= # 0f days between 1 amp;
60.
gt; and so on!
gt; Microsoft Office Excel 2003
Steve G,
This formula woked for the columns and cells that I already had quot;Truequot;.
I have 7 columns; lt;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.

Bebzquot;bebzquot; wrote:

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