Thread
:
Day/Date formula
View Single Post
#
12
Posted to microsoft.public.excel.newusers
Roger Govier
external usenet poster
Posts: 2,886
Day/Date formula
Hi Sandy
Absolutely no need for any apology.
I misread things all the time!!! I put it down to my age - those senior
moments have an increasing frequency<bg
Best wishes.
--
Regards
Roger Govier
"Sandy Mann" wrote in message
...
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
Roger Govier
View Public Profile
Find all posts by Roger Govier