Here's the example workbook, that is similar to the one i am working with.

Try putting the below formula in F2 on Sheet1 and copying down.

=IF(E2="","",IF(E2=15,TEXT(D2,"MMM"),TEXT(EOMONTH (D2,-1),"MMM")))

Then refresh the pivot table and I THINK that does what you need.

Yippe, Thanks, well i was trying with the formula from 2 days and messed it up... Only shifting and 3M's directed it to the condition.... Thank you spencer... Thank you very very much...

Not a problem Rajesh. Always happy to help. :)

Back again with a question with excel formula, The earlier formula was used to create a pivot table, which now is successfully created, but from that pivot table i want to create a comprehensive table which gives total of workload per person irrespective of team, i tried to create an another pivot table from the first one but one cell in header is blank, it is not feasible. So i decided to list down the names of person in table 2, but the problem i cannot figure out feasible way to get an automatic update to return me the sums of above also the header should be repeated with out the team/group name.
Enclosing herewith an example sheet... I know this might be frustrating but please do help....