Mary-lou,

try the tips on this web,

http://www.bettersolutions.com/excel...M012916331.htm

regards from Brazil
Marcelo

"Mary-Lou" escreveu:

I have one worksheet with 52 rows for each week of the year with the
following headings: week #, start date of week and end date of week. I have
another worksheet where I need to forecast expected expenses for new
employees based on the date they start ie. Joe starts in Feb 6 (week 6) and
then calculate expected spend based on remaining weeks in the year. I do
this manually right now. How can I automate this?