Date function

  • Thread starter Thread starter Danny
  • Start date Start date
D

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
 
Hi Danny
this could be a little bit complicated. which definition of weeknumber
do you want to use?
 
Back
Top