I have a sheet that figures dates, it can go back 3 years the user now puts
in the dates for each year needed, it looks like this
4/1/05 to 12/31/05 penalty amt. 39wks 2days Year2005
1/1/06 to 12/31 06 penalty amt. 52wks 1 day Year2006
1/1/07 to 12/31/06 penalty amt. 52wks 1 day Year2007
1/1/08 to 4/1/08 penalty amt. 13wks 1 day Year2008
what I would like to be able to do is change the sheet to have the user only
have to put in the date from to the date to and have the sheet formulate the
rest. The dates don't always go back 3 years it can go back any amount of
time but not longer then 3 years. I not sure how to proceed can any you
steer me in the right direction.