Could you please help me with one more thing..

As per the conditions provided, The EOMONTH(M2,-1) returns me a numerical value, i have formatted these cells to display it as 'mmm', so it shows me as Apr when the deadline date is 05/03/2012 (mm/dd/yyyy). But when i created a pivot table to check the workload per person in an individual month these cells were not considered under the same month but displayed as date separately, which is invalid date, So in pivot table formatted the cells to get MMM, but they are as separate columns.... Could you please help me