Often you may want to fill a column only with weekday dates instead of all dates. Here is a simple trick you can use instead of writing nifty if formulas or manually entering the weekday dates.
When you auto fill dates by dragging mouse (or using menu > edit > fill > series > selecting “type: date”), just use weekdays only option as shown below.
Now you dont have to create project plans with weekends in it 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Google maps 3d building outlines – wow||Excel Paste Special Tricks & How to »|