Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set up week to date report?
I have applied a previous workbook that utilizes two worksheets. Now
everyone in my department would like me to do the same but I am having some difficulty with their request. I have serveral areas in the first worksheet that should pull data from the second worksheet to create the week to date avg for the given area (ie. total hours). My problem is finding a formula that can be copied/pasted that will be the right data in the second worksheet (which is a daily account for each area). Maybe utilizing a VLookup function but I get confused when trying to apply it to week to date. Please help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
urgent pls! sort date pivot report | Excel Discussion (Misc queries) | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Want day of the week when I insert a date | New Users to Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? | Excel Worksheet Functions |