| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFill
I am using autofill to fill in weekdays, but i want it to exclude holidays.
is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AutoFill
If you have your start date in A1 then in A2 you can use the formula =WORKDAY(A1,1,holidays) and copy down column, where holidays is a range of cells containing your holiday dates note: WORKDAY is part of Analysis ToolPak add-in -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=514529 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about tricky autofill for series | Excel Discussion (Misc queries) | |||
| Autofill but with a custom rule?? | Excel Discussion (Misc queries) | |||
| autofill | Excel Discussion (Misc queries) | |||
| More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Hybrid Mode
