I have data in cell A1:A like below 
2/18/2013 7:33
2/19/2013 15:27
2/24/2013 14:01
2/24/2013 14:11
I want data in cell B1:B like below. here today is 2/24/2013, & from here I need to minus one day .date & time format will be (MM/DD/YYYY HH:MM)
2/23/2013 0:00 ' all previous date converted into current date minus one day 
2/23/2013 0:00 ' all previous date converted into current date minus one day 
2/23/2013 14:01 ' here it is same as before only change one day minus 
2/23/2013 14:11 ' here it is same as before only change one day minus