Solution:
I had a formula =IF((O2-L2)> 93, 93, IF((O2-L2)<-32, -32, (O2-L2))) that determined whether or not something was greater than 93 meaning the days were over 93 or less than -32, otherwise take (02-l2). In the next formula i assumed that everything would happen on the first of the month so i took the month from cell (02) and concatenated an "01" to it assuming everything would occur on the first of the month and the current year =VALUE((MONTH(O2)&"/01/"&YEAR(NOW()))). I then took =VALUE((MONTH(O2)&"/01/"&YEAR(NOW()))) and subtracted from the above formula to give me the month and day which i used in my pivot chart. I formated the column to date. if the user selects a month in the pivot chart (i.e august) it will then figure out 93 days back from 8/1/07 and put the values on the chart.
thanks everyone for all your help!!