| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date's
Hello Everybody
I'm trying to combine two date cells in a from - to sense ie Cell 1 has 31/12/03 in it and (formatted dd/mm/yy) cell B2 has 31/12/04 in it (formatted dd/mm/yy) I want cell C3 to show 31/12/03 - 31/12/04 any help welcome |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date's
Hi
=TEXT(B1,"DD/MM/YY") & " - " & TEXT(B1,"DD/MM/YY") -- Regards Frank Kabel Frankfurt, Germany "antinoz" schrieb im Newsbeitrag ... Hello Everybody I'm trying to combine two date cells in a from - to sense ie Cell 1 has 31/12/03 in it and (formatted dd/mm/yy) cell B2 has 31/12/04 in it (formatted dd/mm/yy) I want cell C3 to show 31/12/03 - 31/12/04 any help welcome |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date's
Frank your a Super Star Cheers
Anthony Oz "Frank Kabel" wrote: Hi =TEXT(B1,"DD/MM/YY") & " - " & TEXT(B1,"DD/MM/YY") -- Regards Frank Kabel Frankfurt, Germany "antinoz" schrieb im Newsbeitrag ... Hello Everybody I'm trying to combine two date cells in a from - to sense ie Cell 1 has 31/12/03 in it and (formatted dd/mm/yy) cell B2 has 31/12/04 in it (formatted dd/mm/yy) I want cell C3 to show 31/12/03 - 31/12/04 any help welcome |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference the latest date's data in an array | Excel Worksheet Functions | |||
| can alarm be coded into a cell "x" hours before date's reached ? | Excel Worksheet Functions | |||
| Formula for a date's week number in a month (1st, 2nd, etc.) | Excel Discussion (Misc queries) | |||
Linear Mode
