How do I add numbers in a range of data from days of the week?

  • Thread starter Thread starter Peggy
  • Start date Start date
P

Peggy

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what formula would I use to add information in a range of dates? 1
Dynamic 5-week date range & SUMPRODUCT formulas 0
Formating Day of the week 5
calculating number of days belonging to each month within a given week 2
number of week days in a period of time 5
days of the week formulas 21
Working Days of Week and DUE DATE for PAYMENT 4
Copying daily data from one tab to a weekly summary table 6

Back
Top