View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peggy Peggy is offline
external usenet poster
 
Posts: 47
Default what formula would I use to add information in a range of dates?

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?