P.S.

This formula returns the date serial number. You'll have to format the
formula cell as DATE.

Biff

"Biff" wrote in message
...
Hi!

Try this:

=WORKDAY(A1,12)

The workday function requires the Analysis ToolPak add-in be installed. If
the formula returns #NAME? that probably means you don't have the ATP
installed. If that's the case, goto the menu ToolsAddins.

Biff

"Ziggy M" wrote in
message ...

I need a Formula that will count weekdays only For Example

A1-7/13/06

I am going to need 12 days to complete the task so in another cell i
want it to only count 12 working days (monday to friday) and display
the result in cell c1

any help ?


--
Ziggy M
------------------------------------------------------------------------
Ziggy M's Profile:
http://www.excelforum.com/member.php...o&userid=36338
View this thread:
http://www.excelforum.com/showthread...hreadid=561241