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