Fill dates with weekdays/workdays only

  • Thread starter Thread starter DJ Bjorklund
  • Start date Start date
D

DJ Bjorklund

How do I fill a column's cells with a year's worth of weekdays only?
TIA
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding second-to-last workday of month 4
How to format cell to get first capital letter? 5
calculating only weekdays 6
dates: no weekends and no hollidays 2
Subtract number of Working Days 2
Nesting the ROW() command into a Conditional Format Formula 4
Display workday dates only 4
Find last weekday of the month with vba for all months 3

Back
Top