Re: Counting # of days between 2 dates excluding Fri & Sat)

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,

Now let's have a look how long our formulas take to compute. I ran
them on 5 pairs of dates, 1 day, 1 week, 1 month, 1 year and 10k days
difference and got from FASTEXCEL:
Biff''s SUMPRODUCT 10.61 ms
Mike' NETWORKDAYS 0.23 ms
Biff''s SUM 0.15 ms
Bernd's INT/MOD 0.11 ms

Regards,
Bernd
.

Relevant Pages

  • Re: excel - the need for speed
    ... Mike, unless I'm totally mistaken, Charles Williams "IS" DecisionModels so I ... improving Excel performance. ... I have FastExcel running on a Vista system here and have taken the liberty ...
    (microsoft.public.excel.misc)
  • Re: excel - the need for speed
    ... If you can replace your SUMPRODUCT formulae with Excel 2007 SUMIFS that will ... There are FastExcel users who are happily using FastExcel under Vista. ...
    (microsoft.public.excel.misc)
  • RE: Sumproduct with filters
    ... Thanks for the quick reply Mike. ... Sumproduct gets a bit more complex on a filtered range, ... Column AJ = design improvement cost increase ... I am hoping to be able to filter based on a product category and see the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sum Product
    ... You cannot use full columns in a SUMPRODUCT. ... "Mike" wrote in message ... > I am trying to get a $ sum based on 2 text conditions, ... > to be causing the problem. ...
    (microsoft.public.excel.misc)
  • RE: excel - the need for speed
    ... I love sumproduct but this new exercise has caught me out. ... Anyone have any experienec with ... FastExcel on Vista? ... "Mike" wrote: ...
    (microsoft.public.excel.misc)