Hey thanks man it works now. I just have to change it to be able to ge
the date from the variables instead of having the date hard coded in.

The start_date and End_date variables are pulling the dates from a cel
on another worksheet. So it has to work with those dates

Would this work if I replaced this:

DATEVALUE(""1/7/4"")

with the variable for the start date instead like this

DATEVALUE(Start_date)

and then do the same for the end_date variable. Or is there somethin
else i need to do to make that change

--
Message posted from http://www.ExcelForum.com