How to show a date

[s2m via OfficeKB.com]

I've figured out how to count the number of dates, but how can i just show
the date if there is a date used.

I can use a pivot but i really need to have a formula driven sheet.



LoB 7/3/06 7/5/06 7/7/06 7/10/06
CBNA 7 1 2 8
CFNA 3 14 29 7

 

[Bob Phillips]

What exactly do you want to show?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[s2m via OfficeKB.com]

The date

Instead of having all the days of the month show i only want it to show if
there is a corresponding date in the actual field.

What exactly do you want to show?

I've figured out how to count the number of dates, but how can i just show
the date if there is a date used.

[quoted text clipped - 4 lines]

CBNA 7 1 2 8
CFNA 3 14 29 7

 

[Bob Phillips]

You've lost me. Want it to show ... what is it? if there is a corresponding
date ... corresponding to what?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

The date

Instead of having all the days of the month show i only want it to show if
there is a corresponding date in the actual field.

What exactly do you want to show?

I've figured out how to count the number of dates, but how can i just show
the date if there is a date used.

[quoted text clipped - 4 lines]

CBNA 7 1 2 8
CFNA 3 14 29 7

 

[s2m via OfficeKB.com]

I need a formula that will only show a date if there is a date in that cell

Right now I am using all the dates in a month and using a formula to count if
there is a date in that cell

You've lost me. Want it to show ... what is it? if there is a corresponding
date ... corresponding to what?

The date

[quoted text clipped - 8 lines]