Thanks, See reply from Sheeloo. It was shorter and does work.

"T. Valko" wrote:

Enter the first date in B1. This must be a Monday thru Friday date.

Enter this formula in C1 and copy across as needed:

=B1+CHOOSE(WEEKDAY(B1),0,1,1,1,1,3)

--
Biff
Microsoft Excel MVP


"Sinkguy1" wrote in message
...
I need to enter the date for weekdays only across columns in numerous
worksheets. How can i get the dates for monday thru fridays only stating
with the date in B1?