Quote:
Originally Posted by Spencer101
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...