Combine Weekend Days

[krunk]

I have a date in the following formats 3/24/2013, i have the following formula to calculate the week number in a given month: CONCATENATE("Week"," ",INT((DAY(P2)-2+WEEKDAY(P2-DAY(P2)+1))/7)+1) but now i need to figure out how i can combine the weekend to be 1 day. Thoughts?

[daddylonglegs]

Not sure what you mean - using that formula the Saturday will be in one week and the Sunday will be in the next - do you mean you want that to be different? Can you explain how?