excel spreadsheet
Sorry, to count days use
=SUMPRODUCT(--($B$2:$B$200-$A$2:$A$2000),--($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$20030),--($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)
"bebz" wrote in message
...
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
|