In Cell C65 I have 3/31/2012 in D65 is Sunday. I have tried this, IF(D65="Sat",=DATE(YEAR(C65),MONTH(C65),DAY(C65)-1)
That does not work. I can't seem to figure it out.