Thread
:
Day/Date formula
View Single Post
#
11
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Day/Date formula
Yes, so I just realised. As I said in my 2nd post, I have no idea what I
was thinking about. Once again my apologies.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Roger Govier" wrote in message
...
No Sandy,
If there is no date entered in F2, then just use F1 as Fri, 30 Mar 07.
If there is a date in F2, then use the concatenation of a shortened form
of F1 with " to " and the longer form of F2 date.
as in Fri, 30 Mar to Tue, 03 Apr 07.
--
Regards
Roger Govier
"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