On Wed, 18 Jun 2008 05:48:01 -0700, Anonymous
wrote:

How can I calculate the number of business days between two dates? I tried
using NETWORKDAYS but the answer comes up 0.

Look at HELP for NETWORKDAYS.

If you are using it correctly, there is something wrong with your data.


For example, if you have the transition formula options set, and you are
entering the dates as text and not values, you can get a zero result. This is
because, under those circumstances, the value you enter gets interpreted as a
fractional number and not a date.

Easiest fix would be to deselect the Lotus transition options, and then enter
the dates in fields not formatted as text.
--ron