help trimming off text for a date

[nockam]

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

[Domenic]

Assuming that 04/10/05 is formatted as mm/dd/yy, try the following...

=DATEVALUE(RIGHT(A1,8))+1

Hope this helps!

[nockam]

That works! Thanks! I also found another way for this too....


="Report Printed on "&TEXT((RIGHT(C2,7)+1),"mmmm d, yyyy at h:mm AM/PM")
your answer is simplier though