Populate row with work days
 

Hi all,

I have a worksheet with one cell for start date (A1) and one cell for end
date (A2).

I would like to populate row 3 starting at A3 with all the work days
between start and end date inclusive if start and end date are work days.

I appreciate any assistance.

Populate row with work days
 

On Monday, September 3, 2012 6:29:20 AM UTC-4, (unknown) wrote:
Hi all,



I have a worksheet with one cell for start date (A1) and one cell for end

date (A2).



I would like to populate row 3 starting at A3 with all the work days

between start and end date inclusive if start and end date are work days.



I appreciate any assistance.

Hi
Use this: =NETWORKDAYS(A1,A2)
I don't know what version of Excel you're using so you may need to have The Analysis Toolpak Activated. Go to ToolsAdd-insand check mark Analysis Toolpak
HTH
Cimjet

Populate row with work days
 

On Mon, 03 Sep 2012 10:29:19 GMT, wrote:

Hi all,

I have a worksheet with one cell for start date (A1) and one cell for end
date (A2).

I would like to populate row 3 starting at A3 with all the work days
between start and end date inclusive if start and end date are work days.

I appreciate any assistance.

A3: =IF(WORKDAY($A$1,COLUMNS($A:A))$A$2,"",WORKDAY($A $1,COLUMNS($A:A)))

If you are using a version of Excel prior to 2007, and this formula returns a #NAME error, see HELP for the WORKDAY function for instructions on how to resolve it by installing the Analysis ToolPak.