Dates in a week number

  • Thread starter Thread starter Mike Fogleman
  • Start date Start date
M

Mike Fogleman

How do I find the dates that are in a week number? Assume Sunday is first
day.
 
lets say you have the weeknumber in cell A1, and lets say you want to find
all the 7 days in the year 2005, then use the following formula to get the
first day in your weeknum:

=DATE(2005,1,1)+((A1-2)*7+(8-WEEKDAY(DATE(2005,1,1))))

and then add 1 six times to get the subsequent days.

Mangesh
 
Very good! Thank you.
Mangesh Yadav said:
lets say you have the weeknumber in cell A1, and lets say you want to find
all the 7 days in the year 2005, then use the following formula to get the
first day in your weeknum:

=DATE(2005,1,1)+((A1-2)*7+(8-WEEKDAY(DATE(2005,1,1))))

and then add 1 six times to get the subsequent days.

Mangesh
Click to expand...
 
forgot to mention: you will require to enable the Analysis ToolPak addin to
use the formula below.

Mangesh
 
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

Formula to tell day of week 2
Finding the next dayof the week after a certain date. 4
validate date entered 3
Week No Q 3
Printing Dates on One Sheet 5
week numbers 3
weekday in pivot table 4
Does date in Cell A1 occur between the date in M1 and Date in X1 1

Back
Top