My wife is trying to make an Excel spreadsheet where column A is the date and column B is the weekday. Starting in September and ending in June is the range. Column B is easy, just fill Monday thru Friday all the way down. Column A, we are trying to find a quick way to go, for example, 9/3/12 to 9/7/12, then skip to Monday's date - 9/10. Is there a formula that enters the correct workday and lines up with the correct corresponding day? Any help would be appreciated. Thank you.
Days and Dates without Weekends
- Thread starter gdenison
- Start date
Welcome to chandoo.org gdenison. thanks for your question.
In column B, in first cell (lets say B1) manually enter the start date.
In second cell, write=workday(B1,1) and then drag it down until you see end date.
If you do not want formulas, just type starting date and next date in 2 cells and then drag it down and use "Fill weekdays only option". For more on this refer to - http://chandoo.org/wp/2008/06/30/skip-weekends-while-autofill-dates-in-excel-howto/
In column B, in first cell (lets say B1) manually enter the start date.
In second cell, write=workday(B1,1) and then drag it down until you see end date.
If you do not want formulas, just type starting date and next date in 2 cells and then drag it down and use "Fill weekdays only option". For more on this refer to - http://chandoo.org/wp/2008/06/30/skip-weekends-while-autofill-dates-in-excel-howto/
