calculating only weekdays

[Sinkguy1]

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?

 

[T. Valko]

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)

 

[Sheeloo]

With your first date in A1 enter this in B1 and copy across columns...
Excel 2007
=WORKDAY(A1,1)

Excel 2003
=IF(WEEKDAY(A1+1,2)<6,A1+1,A1+3)

 

[Sinkguy1]

Thanks, I am using 2007 and that was easy. The discription of the function
did not sound like that was what I wanted, but it works great.

 

[Sinkguy1]

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

 

[T. Valko]

Yeah, I didn't even think of using WORKDAY.

Thanks for the feedback!

 

[Ashish Mathur]

Hi,

Enter the first date in cell B1. Now drag down (a couple of rows) the fill
handle at the lower right corner of cell B1 and then release it. You will
see a "Auto Fills Option" box. Click on it, and there will be an option for
weekdays. This assumes Mon-Fri as weekdays.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com