Hi
I too have both array and formula separators as ";". Usually array formulas
work for me, unless I'm trying to use 2D array (which is not the case
here) - like VLOOKUP(value,{val11,val12;val21,val22;...},2,0) - try to
replace all commas with semicolons :-))
But this formula somehow behaves differently with my regional settings.
--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )
"Roger Govier" wrote in message
...
Hi
Like Bob, I have no problem with the original formula.
However, where you have changed "," for ";" because of your language
separator, you need to use a different separator within the array
functions
{0;1;2;3;4;5} as there is a difference in the way an array is treated with
different separators.
If I change the separator from ";" to "," with my UK settings, I can
re-create your problem.
I don't know what the correct separator should be for your language, maybe
you need "," rather than ";"????
Regards
Roger Govier
wrote:
It bugs on me ...
For those with ;-separator instead of ,-separator:
=IF(MONTH(DATE(YEAR(NOW());MONTH(NOW());1))-
MONTH(DATE(YEAR(NOW());MONTH(NOW());1)-
(WEEKDAY(DATE(YEAR(NOW());MONTH(NOW());1))-1)+
{0;1;2;3;4;5}*7+{1;2;3;4;5;6;7}-1);"";DATE(YEAR(NOW());
MONTH(NOW());1)-(WEEKDAY(DATE(YEAR(NOW());
MONTH(NOW());1))-1)+{0;1;2;3;4;5}*7+{1;2;3;4;5;6;7}-1)
But on my first and last row I do not get anything.
On row 2 I got all mondays (all the same), row3: all the same
tuesdays, row4: wedns, row5: thursds
like:
....
ma 05-sep-05 ma 05-sep-05 ma 05-sep-05 ...
di 13-sep-05 di 13-sep-05 di 13-sep-05 ...
....
in 7 columns though.
Strange, strange, strange...