B
brian martens
I have a set of date that needs to be summarized by week. I am using
weeknum to figure out appropriate week for each value and them using
sumif to roll those up week by week. My one remaining problem is
getting dates to display for each week based on the week number. In
other words I want the starting date to display for a week number 6, or
the starting and ending dates, even the ending date for that week. If
I can do that based on week number then I can label the summarized data
set. Any thoughts on how to do that? I've searched for hours now and
no luck.
weeknum to figure out appropriate week for each value and them using
sumif to roll those up week by week. My one remaining problem is
getting dates to display for each week based on the week number. In
other words I want the starting date to display for a week number 6, or
the starting and ending dates, even the ending date for that week. If
I can do that based on week number then I can label the summarized data
set. Any thoughts on how to do that? I've searched for hours now and
no luck.