I want to take the date to the left and minus 3 months; I used the cell ref. - 90 (3 months @ 30 days per mo.) - this worked for the month but not the day; e.g. the days are off by 1 or so.
How can I calculate the date to 3 months prior - but keep the current day the same ??
tks
Tony
6/27/2010 3/28/2010
8/15/2011 5/16/2011
10/3/2010 7/4/2010
10/31/2010 8/1/2010
12/25/2011 9/25/2011
How can I calculate the date to 3 months prior - but keep the current day the same ??
tks
Tony
6/27/2010 3/28/2010
8/15/2011 5/16/2011
10/3/2010 7/4/2010
10/31/2010 8/1/2010
12/25/2011 9/25/2011