M
Mike Fogleman
How do I find the dates that are in a week number? Assume Sunday is first
day.
day.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
M
Mangesh Yadav
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
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
M
Mike Fogleman
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
M
Mangesh Yadav
forgot to mention: you will require to enable the Analysis ToolPak addin to
use the formula below.
Mangesh
use the formula below.
Mangesh