| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Is there a function to show future date | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
Linear Mode
