Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate days of the month in a column by checking on date | Excel Worksheet Functions | |||
Work days | Excel Discussion (Misc queries) | |||
Auto holiday days populate on other sheets | Excel Worksheet Functions | |||
Net Work Days | Excel Discussion (Misc queries) | |||
How to populate a combobox with the name of all the sheets in work | Excel Programming |