Date function

[Danny]

I am looking for a formula that looks at a date and
returns the week number in a month.
Eg date field is April 4 2004 the formula will return what
week in that month that day falls on. i have this code
which tells me the same thing but only what week it is of
the year.
=TRUNC(((D7-DATE(YEAR(D7),1,1))/7))+1+IF(WEEKDAY(DATE(YEAR
(D7),1,1))>WEEKDAY(D7),1,0)

can anyone modify this to return the week in the month?
thnx,
Danny

 

[Frank Kabel]

Hi Danny
this could be a little bit complicated. which definition of weeknumber
do you want to use?

 

[Jason Morin]

Check out a couple of proposed solutions in this thread:

http://tinyurl.com/2krvh

HTH
Jason
Atlanta, GA