Checking previous 7 rows for dates and values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 97.

I am wanting some code which will add an entry on the next free line which
checks the previous 7 rows and if they are within the preceding 7 days the
value of the adjacent cells are added up and entered in the next cell to the
right.

An example of this is:

9/11/04 6
18/11/04 2
19/11/04 2
20/11/04 3
22/11/04 4
23/11/04 5
25/11/04 2

So in this example the following days would be added 19,20,22,23,25
and the following is added and the entry would be:-
26/11/04 16


I hope I’ve explained what I’m after!

Can anyone asisst me.please
Regards
 
Hi Mark,
I can not get my Excel to deal with the date format you are using. I don't
even see that format in Date Format. I am using an American version of Excel,
which might explain the format choices I have available.
 
You must log in or register to reply here.

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

VBA: Copy a date and paste as text 4
Macro Optimization - 25,000+ Rows 19
I need to help with Excel (beginner) -- year row and month column 2
Autofil on variable rows, delete extract and show remaining rows 3
Calculation Project Date skip Sun and Sat 3
Deleting blank cells w/o impacting other rows/columns 3
lookup date in the interval 4
VBA-Graphic 2

Back
Top