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

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

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