Thread
:
Day/Date formula
View Single Post
#
10
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Day/Date formula
"Sandy Mann" wrote in message
...
Roger Govier" wrote in message
... Hi
If 2 cells are going to be used to hold the dates, then
=IF(F2="",TEXT(F1,"ddd, dd mmm yy"),TEXT(F1,"ddd, dd")
&" to "&TEXT(F2,"ddd, dd mmm yy"))
Very good Roger. I assume that the =IF(F2="", is a typo for =IF(F2<"", ?
No of course you didn't! I don't know what I was thinking of, my apologies
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Sandy Mann" wrote in message
...
Roger Govier" wrote in message
... Hi
If 2 cells are going to be used to hold the dates, then
=IF(F2="",TEXT(F1,"ddd, dd mmm yy"),TEXT(F1,"ddd, dd")
&" to "&TEXT(F2,"ddd, dd mmm yy"))
Very good Roger. I assume that the =IF(F2="", is a typo for =IF(F2<"", ?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Roger Govier" wrote in message
...
Hi
If 2 cells are going to be used to hold the dates, then
=IF(F2="",TEXT(F1,"ddd, dd mmm yy"),TEXT(F1,"ddd, dd")
&" to "&TEXT(F2,"ddd, dd mmm yy"))
--
Regards
Roger Govier
"Sandy Mann" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann