Determine weekday counts
 

I'm trying to show the number of days between two dates. The formula
below works, but counts EVERY day. I just want the weekdays counted
(exclude Sat and Sun). Can you assist?

=IF(AND(E20<"",G20<""),DAYS360(E20,G20),"")

Check out the NETWORKDAYS function:-

Returns the number of whole working days between start_date and end_date.
Working days exclude weekends and any dates identified in holidays. Use
NETWORKDAYS to calculate employee benefits that accrue based on the number of
days worked during a specific term.

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.


"Annabelle" wrote:

I'm trying to show the number of days between two dates. The formula
below works, but counts EVERY day. I just want the weekdays counted
(exclude Sat and Sun). Can you assist?

=IF(AND(E20<"",G20<""),DAYS360(E20,G20),"")

That worked great, with one problem - when the dates are the same
(budgeted vs. actual), the result is 1 but should be zero. I added -1
to the end of the formula.

Thanks for your help.

Yeah, but now when the dates aren't the same the calc will be off by 1!

Robbing Peter to pay Paul?

Try this:

=IF(budgeted=actual,0,your_formula_here))

Biff

"Annabelle" wrote in message
oups.com...
That worked great, with one problem - when the dates are the same
(budgeted vs. actual), the result is 1 but should be zero. I added -1
to the end of the formula.

Thanks for your help.