How to show a date
 

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

--
Message posted via http://www.officekb.com

How to show a date
 

What exactly do you want to show?

--
HTH

Bob Phillips

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

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6323530f33d3c@uwe...
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

--
Message posted via http://www.officekb.com

How to show a date
 

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.

Bob Phillips wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

How to show a date
 

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)

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:633147cf0d774@uwe...
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.

Bob Phillips wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

How to show a date
 

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



Bob Phillips wrote:
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]
CBNA 7 1 2 8
CFNA 3 14 29 7

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1