ExcelBanter - Format an excel column as a date for a 5 day week for a year.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format an excel column as a date for a 5 day week for a year. (https://www.excelbanter.com/excel-discussion-misc-queries/2723-format-excel-column-date-5-day-week-year.html)

dabenesch

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?

Peo Sjoblom

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?

All times are GMT +1. The time now is 06:49 AM.