Adding sales from a non working day to the previous working day

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi

I have a spreadsheet that contains daily sales data. Very occasionally, we
have sales recorded against a non working day. What I want to do is to add
these sales to the previous working day as if they were actually taken on
that day.

Example:

This could be the data I start with:

Date Sales
15/09/03 $100
16/09/03 $150
17/09/03 $120
18/09/03 $130
19/09/03 $180
21/09/03 $110
22/09/03 $250

I want to translate this to:

Date Sales
15/09/03 $100
16/09/03 $150
17/09/03 $120
18/09/03 $130
19/09/03 $290
22/09/03 $250

(notice that sales for the Sunday 21st have been added to the 19th)

Any ideas how I can achieve this? I've started to use Vlookup against a
static range that only contains working dates, and this will return the
previous value in the range if the exact value doesn't exist, (so the Sales
on the 21st will return the value 18/09/03) but after that I got stuck.

Thanks in advance

Alex
 
Back
Top