View Single Post
  #10   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Have you tried a Quattro Pro newsgroup? I've haven't had need to go to it,
but here is a place you could try:
http://support.corel.com/scripts/rig...p_faqid=754345

tj

"Rob" wrote:

Thanks again Domenic. In reflection, your first formula will actually do me
better, but thanks for the amendment as may help me with another issue.
Unfortunately, the environment this will be used in is at my office and they
don't use Excel. Strange but true! They use Quattro Pro....ugg! That
program uses all but the Indirect function. Is there another way to do this
without that function?
BTW it works just great in Excel
PS. I tried fiddling with a later post by pj but his formula comes up with
syntax error in Quattro. Nor can I use the Analysis Toolpak as suggested by
Ron

Rob

"Domenic" wrote in message
...
In article ,
"Rob" wrote:

Thankyou so much Domenic and so quick too!
I just need to amend it slightly as your formula does No. of week-end

days
and not No. of week-ends.


I had wondered about that...obviously I guessed wrong...so here you
go... :-)

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1-1)),2)=6),--(WEEKDAY(ROW(IN
DIRECT(A1+1&":"&B1)),2)=7))

Hope this helps!