Date formula

O

olidrugas

Hi

If smb know how to extract from a date _*the_week_of_the_year_*_wher
that date belong

Th
 
G

Gary Brown

Use the formula:-

WEEKNUM(A1,1) or WEEKNUM(A1,2)

1 = Week begins on Sunday. Weekdays are numbered 1 through 7.
2 = Week begins on Monday. Weekdays are numbered 1 through 7.

A1 contains a dat
 
A

Arvi Laanemets

Hi

It depends how you define a week. I myself use the formula
=1+INT((A2-DATE(YEAR(A2+4-WEEKDAY(A2+6)),1,5)+WEEKDAY(DATE(YEAR(A2+4-WEEKDAY(A2+6)),1,3)))/7)
where A2 contains a date. The first week of year is the one with first
Thursday in it, and all weeks are 7 days long (ISO week).
 
B

Bob Phillips

=WEEKNUM(A1)

where A1 holds the date

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top