Spencer101 Spencer101 is offline

Senior Member

Posts: 663

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Logical IF function	Stuck!	Excel Worksheet Functions	2	March 20th 10 09:26 AM
Logical Function excel 2003	Denver	Excel Worksheet Functions	4	June 30th 09 07:01 PM
Help!!! - logical function for someone not very logical	ECH123	Excel Worksheet Functions	3	May 11th 09 04:14 PM
EXCEL 2000 - IF function returns wrong result from logical test	Sean Duffy	Excel Worksheet Functions	8	October 15th 08 09:58 PM
Help with logical function	PT	New Users to Excel	2	February 22nd 08 02:13 AM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us