For your 2nd post and with the start date in F1 and the end date in F2, try
somthing like:

=CHOOSE(WEEKDAY(F1),"Sun","Mon","Tue","Wed","Thu", "Fri","Sat")&",
"&DAY(F1)&" -
"&CHOOSE(WEEKDAY(F1),"Sun","Mon","Tue","Wed","Thu" ,"Fri","Sat") &",
"&DAY(F2)&" "&
TEXT(CHOOSE(MONTH(F2),"Jan","Feb","Mar","Apr","May ","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),"???" )&"
"&YEAR(F2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"86" wrote in message
...
Oh well, I can do without the th's, nd's st's, etc!
Thanks heaps for replying.
Any ideas on my 2nd post?

Cheers


"BoniM" wrote:

Under format cells, number, custom format, enter:
ddd, d mmmm yyyy
to display April 1st:
Sun, 1 April 2007

ddd, dd mmmm yyyy
for this:
Sun, 01 April 2007

I don't know of any way to display ordinal numbers within a date:
Sun, 1st April 2007
as you have in your sample.

"86" wrote:

Is it possible to have a function where if you enter the date
numerically, eg
'30/3/7'
it returns the DAY & date, eg 'Fri, 30th March 2007' ?

This would obviously work off the computer calander so as to ensure it
gets
the day of the week correct.

Thanks