Typo in earlier response just detected ..

Lines:
Then if we want to calc a running total sales for the last 30 days
(inclusive today), we could put in say, C1:

should have read as:
Then if we want to calc a running total sales for the last 3 months
(inclusive today), we could put in say, C1:

Formula's OK, though <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---