Excel Count Weekdays Formula

[Ziggy M]

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
want it to only count 12 working days (monday to friday) and displa
the result in cell c1

any help

 

[Biff]

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

 

[Dave O]

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

 

[Nelly]

Hi,

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

god luck

 

[Guest]

=workday(A1,12)

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

HTH

 

[Biff]

P.S.

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

Biff

 

[Ziggy M]

Amazing Thank You

 

[Biff]

You're welcome!

Biff

 

[mhart210]

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.

 

[Biff]

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