Hi All,
I have a spreadsheet that I would like to be able to LIST the DAYS of the month down a column. I then need to put a formula in the next cell that knows to skip the weekends in the date column.

Anyone have an idea as to how to get this done?

Something like this.....

1/1/2011      Skip Sat
1/2/2011      Skip Sun
1/3/2011      SUM etc...
1/4/2011      SUM etc...
etc...

THANKS

I'd like to KNOW more about that SUM etc... in the right hand column. You want the formula to return 0 if the day is a weekend day and sum some range of cells if it's not?

Thanks for the replay.
In a nutshell the SUM stuff adds 2 cells togther that had nothing to do with the date other then to know to show the RESULTS only on weekdays. In other words we had X left from the day before so the SUM cell would start us on the new day with what was left from the day before. We don't work on the weekends so the SUM would have to skip 2 days and show on the following Monday.

I found a quick work around.....

http://chandoo.org/wp/2008/06/30/skip-weekends-while-autofill-dates-in-excel-howto/

I think that this is a good idea. What do you think?

Thanks
Quote from: Spoiler on January 10, 2011, 12:41:20 PM

I think that this is a good idea. What do you think?