Conditional date formating

[dtrumbower]

I'm displaying data in a cross tab and I need two different date formats. One MMM dd and the other dd. I have tried using a formula with previous and that didn't work and I tried to use the format conditional buttons on the date format dialog screen. It needs to look like the following.

Only on month changes do I want the MMM dd format.

Thanks for any insight given.

Cycle Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 Dec 28 Jan 27 Feb 25 Mar 27 Apr 26 May 25 Jun 27 Jul 27 Aug 25 Sep 26 Oct 25 Nov 27
2 29 28 28 28 27 26 28 28 28 27 26 28
3 30 Feb 1 Mar 1 29 May 1 30 29 Aug 1 29 28 27 29
4 Jan 3 2 2 31 2 Jun 1 Jul 3 2 30 Oct 2 30 Dec 1
5 4 3 3 Apr 3 3 2 5 3 Sep 1 3 Nov 1 4
6 5 4 6 4 4 5 6 4 5 4 2 5
7 6 7 7 5 5 6 7 7 6 5 3 6
8 7 8 8 6 8 7 10 8 7 6 6 7
9 10 9 9 7 9 8 11 9 8 9 7 8
10 11 10 10 10 10 9 12 10 11 10 8 11
11 12 11 13 11 11 13 13 11 12 11 9 12
12 13 14 14 12 12 14 14 14 13 12 10 13
13 17 15 15 13 15 15 17 15 14 13 13 14
14 18 16 16 14 16 16 18 16 15 16 14 15
15 19 17 17 17 17 19 19 17 18 17 15 18
16 20 18 20 18 18 20 20 18 19 18 16 19
17 21 21 21 19 19 21 21 21 20 19 17 20
18 24 22 22 20 22 22 24 22 21 20 20 21
19 25 23 23 24 23 23 25 23 22 23 21 22
20 26 24 24 25 24 26 26 24 25 24 22 26

 

[nagornyi]

Consider doing a manual crosstab. With the fixed number of columns, this is definitely doable. Then you will have more control on the displaying the data. Look into faq149-1219 and faq149-1639.