Re: WEEKDAY()
- From: "Bob Phillips" <bob.NGs@xxxxxxxxxxxxx>
- Date: Sat, 9 Sep 2006 11:32:53 +0100
Hi Epinn,
The "--" is exactly the same as its usage in SUMPRODUCT, it is coercing into
a numeric.
=WEEKDAY(--"21/4/2008") gives #VALUE!
=WEEKDAYS(--"4/21/2008") gives 2.
As RD says the second version of that works for you, but fails for me is
because we have different date settings, yours are American, mine are
European.
But I prefer "/" to "-" and I tested it. I am glad that "/" works too.
The purpose of using the date in the format yyyy-mm-dd or yyyy/mm/dd is to
remove ambiguity (10/09/2006 is 9th Oct to you, it's 10th Sep to me). I
prefer the use of the "-" separator because that is part of the ISO
standard.
I find date functions may be as confusing as SUMPRODUCT().
No, you are just trying to understand properly so that you can use more
effectively. Nothing wrong with that. I answered a post on another forum
where a guy gave totally misleading information about SUMPRODUCT as if it
were gospel. It didn't affect the solution, which worked, but should the OP
have tried to take it further, he would really have gotten confused. I don't
see that happening to you.
And if you think dates are confusing, just pity us developers who work in
both markets, catering for all forms can be really challenging.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
.
- Follow-Ups:
- Re: WEEKDAY()
- From: Epinn
- Re: WEEKDAY()
- References:
- WEEKDAY()
- From: Epinn
- Re: WEEKDAY()
- From: Bob Phillips
- Re: WEEKDAY()
- From: Epinn
- WEEKDAY()
- Prev by Date: Re: WEEKDAY()
- Next by Date: Re: WEEKDAY()
- Previous by thread: Re: WEEKDAY()
- Next by thread: Re: WEEKDAY()
- Index(es):
Relevant Pages
|
