| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format an excel column as a date for a 5 day week for a year.
Is there an easy way to format a column as a date for a year showing only
Monday through Friday? |
|
#2
|
|||
|
|||
|
Put a date in the first cell, right click copy down, then select fill weekdays
Regards, Peo Sjoblom "dabenesch" wrote: Is there an easy way to format a column as a date for a year showing only Monday through Friday? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Linear Mode
