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) |