| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Fill dates with weekdays/workdays only
How do I fill a column's cells with a year's worth of weekdays only?
TIA |
|
#2
|
|||
|
|||
|
Enter the first date. Right-click the fill handle in the lower right
corner of the cell and drag down about 270 rows. Choose Fill Weekdays from the menu that pops up when you release the mouse. In article , DJ Bjorklund wrote: How do I fill a column's cells with a year's worth of weekdays only? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
