Day/Date formula
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
|