Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to add income from the days of one work week together. I then
want to build my spreadsheet so I can look at different weeks in a month. I thought I would build in a button to give me this option to either view the information daily or weekly. The hardest bit is trying to build a formula that's cleaver enough to give me this weekly information? Also when two months merge together for example March 30th - 5th April. Any thoughts of where I begin? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can achieve this by formulas itself. Just to start please share with us
what data you already have..Is that columns like date,income If this post helps click Yes --------------- Jacob Skaria "Peggy" wrote: I am trying to add income from the days of one work week together. I then want to build my spreadsheet so I can look at different weeks in a month. I thought I would build in a button to give me this option to either view the information daily or weekly. The hardest bit is trying to build a formula that's cleaver enough to give me this weekly information? Also when two months merge together for example March 30th - 5th April. Any thoughts of where I begin? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
5 working days of a week | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel | |||
7 days of the week | Excel Discussion (Misc queries) | |||
Days of the week. | Excel Worksheet Functions |