Date Format

[wid2001]

I am scraping data from a flight planning website that brings a date value into a cell like this: "Tue. 7/26". Currently I have the formula "=RIGHT(X42,2)" to extract the day and "=MID(X42,6,1)" to extract the month. This formula doesn't work all of the time depending on whether or not the day is 1 or 2 digits. For the above example I have to modify it to "=RIGHT(X42,3)". I know there is probably a better solution than modify the formula every time its a two digit or single digit day. I need the day and month seperated and available for other calculations. Anyone have any ideas?

Thanks

 

[Weazel]

maybe something like....

=DAY(REPLACE(A2,1,FIND(" ",A2),"")+0)
=MONTH(REPLACE(A2,1,FIND(" ",A2),"")+0)

?

 

[wid2001]

That seems to be working great. Thanks for the reply! I will try and break it but that seems to have solved my problem.