Your stars: ***
Thanks!
>>>>If I have a date in column A: 09/21/2005
>>>>
>>>>I need to get the following text string in column B: "09/20 & 09/21"
>>>>
>>>>The day and the prior day from the date in column A.
>>>>
>>>>Easy in Foxpro. Can't figure it out in Excel...
>>>
>>>Jay,
>>>Try this
>>>
=TEXT(MONTH(A1);0) & "/" & TEXT(DAY(A1)-1;0) & " & " & TEXT(MONTH(A1);0) & "/" & TEXT(DAY(A1);0)
>>
>>It's telling me that I have an error in the formula. Did you test it using a date in column A?
>
>Yes, I test.
>Format cell 'A' as date and follow another supposition of Hilmar.
>HTH