excel spreadsheet

B

bebz

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
 
S

SteveG

You can use the DATEDIF function.

=DATEDIF(A1,AE1,"d")

This is where the two dates that you are using are located in cells A
& AE1. The "d" tells the formula to calculate days. This include
weekends an holidays.

HTH

Stev
 
B

Bob Phillips

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200>0),--($B$2:$B$200-$A$2:$A$200<=30))

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200>30),--($B$2:$B$200-$A$2:$A$200<=60))

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bob Phillips

Sorry, to count days use

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200>0),--($B$2:$B$200-$A$2:$A$200<=30),$B
$2:$B$200-$A$2:$A$200)

and

=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$200>30),--($B$2:$B$200-$A$2:$A$200<=60),$
B$2:$B$200-$A$2:$A$200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

bebz

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
 
Top