G
Guest
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
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