Excel function (within a function)

L

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
 
F

Frank Kabel

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

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
 
Top