Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
I need to create a planner - previously have manually inputted all the Mon
Tue dates and click and dragged the rest but wondered if there was a better way. Need M, T, W, T, F dates skip weekend, start again. Have tried doing it by dragging over a 2 week period to see if the pattern is recognised but it doesn't work. Laurina |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Not quite. Here's an example
M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Hi Laurina
Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Thanks for that but the file isn't recognising the workday bit - comes up
with #name and then #ref. "Roger Govier" wrote: Hi Laurina Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Hi Laurina
I should have added that you need the Analysis Toolpak loaded. ToolsAddins and check Analysis Toolpak -- Regards Roger Govier "Laurina" wrote in message ... Thanks for that but the file isn't recognising the workday bit - comes up with #name and then #ref. "Roger Govier" wrote: Hi Laurina Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
Laurina
The WORKDAY Function is from the Analysis Toolpak Add-in. Load it through ToolsAdd-ins to eliminate the #NAME! error. Gord Dibben MS Excel MVP On Tue, 25 Apr 2006 09:25:01 -0700, Laurina wrote: Thanks for that but the file isn't recognising the workday bit - comes up with #name and then #ref. "Roger Govier" wrote: Hi Laurina Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
thanks. Have done this but #ref doesn't go away. possibly something to do
with the server?? "Roger Govier" wrote: Hi Laurina I should have added that you need the Analysis Toolpak loaded. ToolsAddins and check Analysis Toolpak -- Regards Roger Govier "Laurina" wrote in message ... Thanks for that but the file isn't recognising the workday bit - comes up with #name and then #ref. "Roger Govier" wrote: Hi Laurina Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series - I think!
ignore last message - had entered date as text - it now works - thanks
"Roger Govier" wrote: Hi Laurina I should have added that you need the Analysis Toolpak loaded. ToolsAddins and check Analysis Toolpak -- Regards Roger Govier "Laurina" wrote in message ... Thanks for that but the file isn't recognising the workday bit - comes up with #name and then #ref. "Roger Govier" wrote: Hi Laurina Try using the Workday() function. With your first date in A1, in A2 enter =WORKDAY(A1,1) Copy down and you will just get the workdays of each week. If you want to exclude Public Holidays from the list, then pout those dates in a range of cells and either name the range as Holidays or refer directly to the range of cells holding the dates with the following modified formula =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds the range of holiday dates. -- Regards Roger Govier "Laurina" wrote in message ... Not quite. Here's an example M 28-Sep T 29-Sep W 30-Sep Th 1-Oct F 2-Oct M 4-Oct T 5-Oct W 6-Oct Th 7-Oct F 8-Oct "Petitboeuf" wrote: Laurina I am using Excel 2003 and I have tried the following: Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday in columns A to J. When i select the lot then drag to the right it starts from Monday then end the week on Friday, then starts again with Monday, etc... Is this what you are after? -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=535963 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO USE FILL SERIES | New Users to Excel | |||
Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
Fill Series option grayed out | Excel Discussion (Misc queries) | |||
fill series | Excel Discussion (Misc queries) | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) |