Excel function (within a function)

[Lynxbci3]

Hello,

I have a function which creates a date (format = 07/08/04) and withi
the function i would like to use WEEKNUM(). However you can not us
functions within functions or can you

 

[Frank Kabel]

Hi
you can. You may explain what you're trying to do exactly
and also post your existing formula

 

[Dave Peterson]

Instead of creating the date in 07/08/04 (which could mean lots of different
things to different people ymd/mdy/dmy, etc)

How about just creating the date unambiguously?

=date(year,month,day)
=date(a1,a2,a3)

so
=weeknum(date(a1,a2,a3))

might be one way to go.

And you didn't ask, but weeknumbers are pretty strange, too. See Chip Pearson's
site:
http://www.cpearson.com/excel/weeknum.htm