Compute weekly values from the monthly data
Good day.
I would like to seek help on my problem computing values on a weekly basis.
I have a monthly list of employee's sales, but I also wanted to compute the weekly sales based on the given monthly data.
I have attached my file to further elaborate.
Thanks.
Last edited by berto; 10-22-2011 at 07:46 PM.
How's the attached file for you? It uses a formula in cell H5 (hidden using white text on a white background) to calculate the start date for the first week and then increments that for each week using the row that the weekly formula appears on.
Is this the sort of thing you were looking for?
That's exactly what I was looking for!
That's just the perfect solution!
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks