Finding the date using the number of the week in a year

B

Bhupinder Rayat

Hi All,

I have manipulated some data and managed to get the week number of each row
and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in
any particular year.

e.g. for today (27 Mar 2007):
week number = 13
year = 2007
day = 2 (2 for tuesday).

Using this data, is there anyway i can return the actual date for today
(e.g. 27-Mar-07) using a formula ?

Any help would be much appreciated.

Regards,

Bhupinder.
 
J

JE McGimpsey

One way:

A1: 2007
A2: 13
A3: 2

B1: =DATE(A1,1,A2*7-WEEKDAY(DATE(A1,1,0))+A3-6)
 

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

Need some PWA help 0
Search closest day in the past from today 2
Formula to tell day of week 3
week numbers 7
Finding the date of the previous Thanksgiving Day 11
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Finding the right function & formula 4
Finding the next dayof the week after a certain date. 4

Top