I have a cell that has "Date: 04/10/05" I am going crazy trying to figure out a way to get just the date part then add a day to it. Anyone have any ideas? I have tried a few things such as setting the formatting as a date, then using the left function to get just the date, then trying to reference that cell and add 1 to it. any help would be greatly appreciated. Thanks

garrett