Calendar Issue

[claird]

I am trying to build a pretty basic mileage log in excel. I want column A to be a date in a month, for example 7/1/2015. The problem I am having is how do I get excel to know to skip weekends. For example, 7/1/2015 was a Wednesday. I want to drag that date down but I want excel to know that the 4th and 5th were weekends and to skip them. I plan to use the same sheet each month and ideally I could begin my next month with 8/3/2015 and it would know that day is a Monday. Any help would be greatly appreciated.

 

[JoeMo]

If A1 is a weekday date this will exclude weekends. Copy the formula in A2 down as far as you need to go.

Excel Workbook
	A
1	8/3/2015
2	8/4/2015
3	8/5/2015
4	8/6/2015
5	8/7/2015
6	8/10/2015
7	8/11/2015
8	8/12/2015
9	8/13/2015
10	8/14/2015
11	8/17/2015
Sheet12

 

[claird]

when I use this formula it simply skipped to every other day. it went 8,10,12,14,16 etc,

 

[claird]

nevermind I didn't change the A1 in the equation too

 

[JoeMo]

nevermind I didn't change the A1 in the equation too

You just need to copy the formula down - the A1 will change automatically.