I have a column of days, Monday through Sunday for the last three years. In the column next to it I have a 0 to exlcude that day and a 1 to include that day. I need to be able to count the numbers using the column with 0 or 1 given a certain date range. An example would be 7/15/2010 to 8/15/2010 would be 31 actual days, but would only 20 open business days. Need to count the open business days, there are more then just the 7/1/2010 to 8/15/2010 ranges.
Hi NissanX,
Look at http://www.pivot-table.com/2010/03/0...-date-filters/
It might be that 2010 excel has the "between" feature and 2007 doesn't. Time to upgrade? See if 2007 has this feature.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You can use SUMIFs, e.g. if dates are in column A and 1/0 in B try
=SUMIFS(B:B,A:A,">="&D2,A:A,"<="&D3)
where D2 and D3 contains the start and end dates
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks