Text in DAtes
 

Hi

Please allow me to explain my problem I have a spreadsheet with two work
sheets in it one called holiday and the other called months

In the months sheet I have 12 colums labeled from January through to
December with the date looking like this 01/01/06 and 01/12/06

On the holiday spreadsheet I want to display those dates with the Day at the
top and underneath in the same cell the actual date like this Wed

02/02/06


Now I know to do this if the date are on the same page but not sure how if
the dates are on a different sheet.

This is the code I have =TEXT(IG2,"ddd") & " " & TEXT(IG2,"dd/mm/yyyy") but
that is if the date are on the same sheet when I try and change the location
where it looks I get an error

Many thanks in advance

N/A

Text in DAtes
 

=TEXT(Months!IG2,"ddd")

--
HTH

Bob Phillips

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

"Joel" wrote in message
...
Hi

Please allow me to explain my problem I have a spreadsheet with two work
sheets in it one called holiday and the other called months

In the months sheet I have 12 colums labeled from January through to
December with the date looking like this 01/01/06 and 01/12/06

On the holiday spreadsheet I want to display those dates with the Day at
the
top and underneath in the same cell the actual date like this Wed

02/02/06


Now I know to do this if the date are on the same page but not sure how if
the dates are on a different sheet.

This is the code I have =TEXT(IG2,"ddd") & " " & TEXT(IG2,"dd/mm/yyyy")
but
that is if the date are on the same sheet when I try and change the
location
where it looks I get an error

Many thanks in advance

N/A