Populate row with work days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
Click to expand...

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 Tools>Add-ins>and check mark Analysis Toolpak
HTH
Cimjet
 
Back
Top