Excel Count Weekdays Formula

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 ?

The formula is
=WORKDAY(A1,12)
but it can be expanded to include a list of holidays: check out Help.

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 Tools>Addins.

Biff

"Ziggy M" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Hi,

try NETWORKDAYS() function - just search help as not sure how it works.
just have start/end date parameters I believe.

god luck

Ziggy M wrote:
> 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

=workday(A1,12)

This is part of analysis toolpak (Tools=>Add-ins=>Analysis Toolpak)

HTH

"Ziggy M" wrote:

>
> 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
>
>

P.S.

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

Biff

"Biff" <[email protected]> wrote in message
news:[email protected]...
> 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 Tools>Addins.
>
> Biff
>
> "Ziggy M" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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
>>
>
>

Amazing Thank You

You're welcome!

Biff

"Ziggy M" <[email protected]> wrote in
message news:[email protected]...
>
> Amazing Thank You
>
>
> --
> 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
>

Just an after thought, but if you need to account for holidays, you can use NETWORKDAYS. This will allow you to create a list of holidays that will be skipped in addition to Saturday and Sunday. Please note that this also requires the analysis toolpak to be installed.

"mhart210" <[email protected]> wrote in
message news:[email protected]...
>
> Just an after thought, but if you need to account for holidays, you can
> use NETWORKDAYS. This will allow you to create a list of holidays that
> will be skipped in addition to Saturday and Sunday. Please note that
> this also requires the analysis toolpak to be installed.

The WORKDAY function also has an optional holidays argument.

Syntax

WORKDAY(start_date,days,holidays)

Biff