Ken,
when you say "If x were an array" do you mean the date?

Paul

"Ken Wright" wrote in message
...
LOL - Hi Harlan, long time no speak ;-)

I had posted a different solution because I'd already done something very
similar to what I believe the OP was after, but that having been said I'll
tuck that one away with the others, cheers.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Harlan Grove" wrote in message
...
"Ken Wright" wrote...
You are correct in that WEEKNUM is a PITA function that does not work
in an array. :-(
...

So improvise. If x were an array and you wanted what should be the array
result from WEEKNUM(x), try

=1+INT((x-DATE(YEAR(x),1,1)+WEEKDAY(DATE(YEAR(x),1,1),2))/7)




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 24/11/2004