On Thu, 6 Jan 2005 12:53:03 -0800, "Aviator"
wrote:

=COUNTIF(A1:A100,"<" & NOW())

This works good for specific cells. I have a similar question.

How would I do the same thing given that:
1) You only have a starting date
2) Your only wanting to count work days (in this case 4 day/wk) up to NOW()

Thank you for all your help.

Aviator

If you were using a five day work week, you could use the NetWorkdays function
in the Analysis Tool Pak.

But since you are using a four day work week, you need a different solution.

If your workdays are Monday, Tuesday, Wednesday and Thursday, then the
following formula might work for you:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(StartDate&":"&TODAY())))={2, 3,4,5}))

Note that the array constant is where you enter the weekdays (with Sun = 1) for
your workdays.


--ron