hi i have a sheet that contains a column with dates from jan to dec which i
have also formated as a table. i have a sheet also formatted as tables
representing the 12 months, but in this 2nd sheet the mothns are sprated by 3
merged rows and i want to get the dates enterd in the date sheets to refelect
in the second sheet. it does happen when i use =and select the the sheet tab.
all i want know is how can i get it so that when there is no date it will not
show a zero zero but N/A or nothing

If you use this custom format it will show blank when the value is zero:
General;-General;€�€�
If you use this custom format it will show €œNo Date€� when the value is zero:
General;-General;€�No Date€�

Tom