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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

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

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Formula to tell day of week 2
Number of hrs worked in a week, based on dates in a different column 1
week numbers 3
Count Week Of Month 4
Finding the next dayof the week after a certain date. 4
Finding the right function & formula 4
Future date with six day week including holidays 1

Back
Top