View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nick nick is offline
external usenet poster
 
Posts: 192
Default Calculating last 3 months

I am currently using a spreadsheet to keep a record of hours worked a week
for the year.
i have set up as follows: jan1. jan8. jan15. Jan22 etc.
42:11 30:12 15:17 50:40

I want to create a table below to show the last 3 weeks only, and to change
when i enter in the main table each week.