| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula/help
I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010
(Friday) but I need to skip Saturday and Sunday. Is there an easy way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula/help
Hi,
With your start date in a1, put this in B1 and drag down =WORKDAY(A1,1) If you get the name error then Tools\Addins and check the analysis toolpak or without the ATP =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1) Mike "Confusicous" wrote: I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010 (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula/help
One way........
1-Fill the cells down for the year including the Saturdays and Sundays 2-Re-format the column to "Custom dddd" so the names of the days will show 3-Data Filter Autofilter and choose "Saturday" from the dropdown 4-Delete those rows 5-Choose "Sunday" from the dropdown 6-Delete those rows 7-Data Filter Autofilter to return to normal 8-Reformat the column for the date style you prefer. Vaya con Dios, Chuck, CABGx3 "Confusicous" wrote in message ... I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010 (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula/help
Thanks a ton! Worked perfectly
"Mike H" wrote: Hi, With your start date in a1, put this in B1 and drag down =WORKDAY(A1,1) If you get the name error then Tools\Addins and check the analysis toolpak or without the ATP =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1) Mike "Confusicous" wrote: I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010 (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula/help
If that don't beat all............pretty cool Mike
Vaya con Dios, Chuck, CABGx3 "Mike H" wrote in message ... Hi, With your start date in a1, put this in B1 and drag down =WORKDAY(A1,1) If you get the name error then Tools\Addins and check the analysis toolpak or without the ATP =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1) Mike "Confusicous" wrote: I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010 (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Linear Mode
