Fill dates with weekdays/workdays only

J

JE McGimpsey

Enter the first date. Right-click the fill handle in the lower right
corner of the cell and drag down about 270 rows. Choose Fill Weekdays
from the menu that pops up when you release the mouse.
 
G

Gilbert De Ceulaer

Set 1ste weekday in H29 (in 2005 : "03/01/2005")
then in h30->h(as much as you like):
=IF(WEEKDAY(H29;2)=6;H29+3;IF(WEEKDAY(H29;2)=7;H29+2;H29+1))
OK ?
Gilbert
 
Top