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