I did a search to see if I could find this already solved, but after reading 6 or 7 threads, none quite fit, and I'm in no rush, so...

What I need to do is pull just the day portion of a date in order to subtract it from the number of working days in a month.

I use 27 days as my 'month' ...that is how many days we are typically open. I like to base our goals on daily production, so I want to break our monthly objectives into daily... and I'd like to have this sheet alter the required pace as production results are compared to goals.

anyone know how to yoink the 13 out of 11/13/2012? If I could figure that out, I'd be able to cobble the rest together.


thankee

Lj