Date formula

  • Thread starter Thread starter olidrugas
  • Start date Start date
O

olidrugas

Hi

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

Th
 
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
 
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).
 
=WEEKNUM(A1)

where A1 holds the date

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am looking for a formula which extracts a list from data in sheet1to sheet2 filtered by a starting 1
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Help with formula 1
Index with partial text 1
Formula to give special date format but with addition? 3
Can't change the cell back to blank when there is a date in it. 0
Advanced Filter problem 3
Duff Date Text 3

Back
Top